Forum Discussion
Loading Parquet files from ADLS GEN2 to Power Bi Desktop
I am using Databircks to process data frames and storing in ADLS Gen 2 in DELTA/PARQUET format. I would like to load this to Power BI Desktop and build analytics. Its not working. Files stored in JSON format is working fine. I would like to know if Parquet format is supported in power bi ? If so whats the pocess to load in to Power BI desktop.
Thanks
Amit
5 Replies
- amitchandak
Super User
Please refer :
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#connectivity
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin - v-eachen-msft
Community Support
Hi Anonymous ,
Here is the document for your reference.
https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage
Thank you for providing the link. In th post its mentioned to covert the file to text format before connecting to Power BI. However thats not going to work for us. We want to read the parquet files from ADL Gen2 as its and build analtics/reports on it. I would like to know does Power BI has connector to read Parquet files.
Thanks
Amit
- GoingIncognito
Advocate III
I am looking into this also. Haven't figured the best way out yet - but here's one more link on using Apache drill
http://www.johndehavilland.com/blog/2019/06/10/parquet-files-with-powerbi.html
