Loading Parquet files from ADLS GEN2 to Power Bi Desktop

[Anonymous]

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

[Anonymous]

yes parquet format it's support in power bi, on your query try to use the M function "Parquet.Document"

be careful with the version of the file that you reads if you are using delta lake on you adl with databricks.

[v-eachen-msft]

Hi @Anonymous ,

Here is the document for your reference.

https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage

[Anonymous]

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]

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

[amitchandak]

Please refer :

https://community.powerbi.com/t5/Power-Query/Source-ADLS-Gen-1-parquet-file-with-Power-BI/td-p/64313...

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