Loading Data Files in Power BI Desktop
Last updated
Was this helpful?
Last updated
Was this helpful?
Power BI Desktop can load the following data file formats:
Compressed CSV (csv.gz
)
Parquet (.parquet
)
Download and save the data files to a suitable location. In the examples that follow, the data has been saved to C:\data
.
You can use the below steps as a guide on how you can load compressed (Gzip) CSV data files in Power BI Desktop.
On the Power BI ribbon, click Get Data > Blank Query
.
Use the Advanced Editor to add a Power Query M expression like the following to the blank query. This will allow the compressed (Gzip) data file to be loaded directly.
Click 'Done' on the Advanced Editor window and a preview of the data should appear.
Apply the 'Use First Row as Header' transformation and rename the query to something appropriate.
Click 'Close & Apply' to load the data into the data model.
You can use the below steps as a guide on how you can load Parquet data files in Power BI Desktop.
Click 'Get Data' from the Power BI ribbon and then 'More...'.
Click 'Parquet' in the list of data sources and then click 'Connect'.
Enter the path of the data file.
When presented with a preview of the data, click 'Load'.
The data will be loaded into the data model.
Guidance on how to analyse data in Power BI Desktop is beyond the scope of this documentation.
You may find the following helpful: