Import data from data lake to Power BI

[Anonymous]

Hi Community,

I have exported the entity store to Azure Data lake. Now I am trying to import data from Azure Data Lake Gen2 to power bi. The data is coming in Power BI but instead of the column headers, it is coming like Column1, Column2, etc. Kindly help.  It's urgent. Requesting all to help. 

[Anonymous]

Hi Stephen and Amit,

Thanks for your reply. 

Stephen-- No the error is not during connecting to the dataflow in Power BI Desktop. There is nothing to do with dataflow. I am facing the error during importing data in PowerBI desktop through  'Azure Data lake Gen2' through 'Get data'. The columns are coming as Column1, Column2, Column3... and so on rather than the original column names. The original Columns doesn't exist anywhere in the dataset. 

Amit-- I hope your question is answered in my reply above. There is nowhere, the original column names exist in the imported dataset, that I can use the feature, 'the first row as header'.

Kindly help.

[v-stephen-msft]

Hi @Anonymous ,

Do you mean you have an error when connecting to the dataflow in Power BI Desktop? 

You can check your dataflow in Power BI Service.

Reference: https://radacad.com/getting-started-with-dataflow-in-power-bi-part-2-of-dataflow-series

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Are you getting header as data, as the first row?