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
Anonymous
Not applicable

Import data from data lake to Power BI

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. 

3 REPLIES 3
Anonymous
Not applicable

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
Community Support
Community Support

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.

dataflow-settings.png

 

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
Super User
Super User

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.