Skip to main content
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

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. 

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.

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.






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.

Super User
Super User

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

Helpful resources

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.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors