Source ADLS Gen 1 parquet file with Power BI

[the_clown]

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

[Anonymous]

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]

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

[the_clown]

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

[v-piga-msft]

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

[v-piga-msft · 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