Forum Discussion

the_clown's avatar
the_clown
New Member
7 years ago
Solved

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

Need Help
Show and Tell
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

5 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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's avatar
      the_clown
      New Member
      7 years ago

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

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.