/    /  Power BI – Connecting to Data Source

Power BI – Connecting to Data Source

 

Power BI Desktop allows you to connect to a wide range of data sources to create reports and dashboards. You can connect to data sources such as Excel spreadsheets, SQL Server databases, SharePoint lists, and cloud-based data sources like Azure SQL Database, Azure Data Lake Storage, and more.

Here’s how you can connect to a data source in Power BI Desktop

  • Open Power BI Desktop and go to “Home” > “Get Data” in the ribbon.
  • In the “Get Data” dialog, select the type of data source you want to connect to, such as “Excel” or “SQL Server”.
  • The following example shows connecting to web data.

p

  • Follow the prompts to specify the connection details for the data source, such as the file path or server name, and any required credentials.

p

  • Once you have specified the connection details, click “Connect” to connect to the data source.
  • Power BI Desktop will load the data from the data source and present you with a preview of the data.
  • In the “Preview” window, you can select the tables and columns you want to include in your report.
  • Once you have selected the data you want to include, click “Load” to load the data into Power BI Desktop.
  • The loaded data will appear in the “Fields” pane on the right side of the Power BI Desktop window. You can use the data to create your reports and dashboards.