Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
the_clown
New Member

Source ADLS Gen 1 parquet file with Power BI

I'm loading data from a SQL server to ADLS Gen 1 (Azure datalake storage gen 1) in parquet format with ADF (Azure Data Factory).

Parquet files are not compressed. 

 

Is there a native connector to ADLS Gen 1 Parquet files? If even possible.

 

Thank you in advance

1 ACCEPTED SOLUTION

Hi @the_clown ,

 

You could try with Azure Data Lake Store connector in Power BI Desktop. 

 

However, you'd better convert it to txt format before get data in power bi.

 

More details, please refer to this guide document.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

I have exactly same requirement of Fetching and Visualizing data in Apache Parquet files from Azure Data Lake Storage Gen1. Kindly provide some steps to resolve this requirement.

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @the_clown,

 

I have a little confused about your scenario.

 

Do you want to find a connector to get data with ADLS Gen 1 Parquet files in Power BI Desktop?

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Correct, Is it possible to query ADLS Gen 1 Parquet files in Power BI Desktop

Hi @the_clown ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @the_clown ,

 

You could try with Azure Data Lake Store connector in Power BI Desktop. 

 

However, you'd better convert it to txt format before get data in power bi.

 

More details, please refer to this guide document.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors