Power BI Desktop can connect to a variety of data sources, such as local databases, worksheets, and cloud-based data. However, the data you gather from these sources may not always be in the best format for analysis. To improve the structure of your data, you can transform it using Power BI Desktop. This includes splitting and renaming columns, changing data types, and creating relationships between columns.
In this article, we will be discussing:
-How to connect to data
-How to import data to Power BI Desktop
Power BI Desktop can connect to a wide variety of data sources, including on-premises databases, Microsoft Excel workbooks, cloud services, and generic data sources. There are about 60 Power BI-specific connectors for cloud services, such as GitHub and Marketo. You can also connect to generic sources through XML, CSV, text, and ODBC. Power BI can even extract tabular data directly from a website URL.
Connect to Data
When you start Power BI Desktop, you can choose to Get Data from the ribbon on the Home tab.
Power BI Desktop offers a variety of data sources that you can connect to. To do this, select the data source you want to connect to and then follow the instructions. Depending on the data source you choose, you may be prompted to browse your computer or network for the data source file. You may also be prompted to sign in to a service to authenticate your request.
Import the Data
After connecting to a data source in Power BI Desktop, you will see the Navigator window. The Navigator window displays the tables or entities of your data source. You can select a table or entity to see a preview of its contents. You can then import the selected tables or entities immediately by selecting Load, or you can transform and clean the data before importing by selecting Transform Data.
Once you have selected the tables you want to bring into Power BI Desktop, you can either load them immediately by selecting the Load button, or you can transform the data first by selecting the Transform Data button. If you choose to transform the data, you can use the Transform Data window to filter, clean, and modify the data before loading it into Power BI Desktop. For example, you could filter the data to only include a subset of customers or a specific country or region.
Power BI Desktop can import data from a wide variety of sources, including on-premises databases, cloud services, and generic data sources. This means that you are likely to find a way to import the data you need into Power BI Desktop, regardless of the format or location of the data.
SWETA SARANGI