Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
LeonardBagos
New Member

Dynamic Excel Dataset

Hello. Is there a good tool we can use to handle dynamic excel datasets (column name format might change, order of columns might change) before connecting it to Power BI? My client wants it that way, I have explained that we need to be specific and consistent in the format of excel sheets, so we will not encounter errors in our Power BI. But is there any solution for this dynamic dataset. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks for the reply from rajendraongole1 , please allow me to provide another insight: 
Hi  @LeonardBagos ,

 

As far as I know, Power BI temporarily does not support direct synchronization of the data source after the change of the column name, if you change the name of the column in the data source, power bi or in accordance with the old column name to get the data in the data source, matching the new name of the column may appear an error message " The column 'columnname ' of the table wasn't found".

So when the data model changes, we can go to Power Query to manually refresh it.

Solved: Expression.Error: The column 'Column1' of the tabl... - Microsoft Fabric Community

Or click on Advanced Editor and find the relevant column name to replace it.

Solved: Synchronisation error after renaming column in sou... - Microsoft Fabric Community

Solved: Datasource column name changed - Microsoft Fabric Community

Or go into the data source setting and clear all permissions - then recapture them.

vyangliumsft_0-1723530753100.png

Solved: Re: Removing any columns causes errors - Microsoft Fabric Community

This is the related document, you can view this content:

[Expression.Error] The column of the table wasn't found when load into - Microsoft Community

Expression.Error: Column ' ' of the table not found. Trying to refresh - Microsoft Community

Solved: Error: The column '' of the table wasn't found. - Microsoft Fabric Community

 

Best Regards,

Liu Yang

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thanks for the reply from rajendraongole1 , please allow me to provide another insight: 
Hi  @LeonardBagos ,

 

As far as I know, Power BI temporarily does not support direct synchronization of the data source after the change of the column name, if you change the name of the column in the data source, power bi or in accordance with the old column name to get the data in the data source, matching the new name of the column may appear an error message " The column 'columnname ' of the table wasn't found".

So when the data model changes, we can go to Power Query to manually refresh it.

Solved: Expression.Error: The column 'Column1' of the tabl... - Microsoft Fabric Community

Or click on Advanced Editor and find the relevant column name to replace it.

Solved: Synchronisation error after renaming column in sou... - Microsoft Fabric Community

Solved: Datasource column name changed - Microsoft Fabric Community

Or go into the data source setting and clear all permissions - then recapture them.

vyangliumsft_0-1723530753100.png

Solved: Re: Removing any columns causes errors - Microsoft Fabric Community

This is the related document, you can view this content:

[Expression.Error] The column of the table wasn't found when load into - Microsoft Community

Expression.Error: Column ' ' of the table not found. Trying to refresh - Microsoft Community

Solved: Error: The column '' of the table wasn't found. - Microsoft Fabric Community

 

Best Regards,

Liu Yang

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

rajendraongole1
Super User
Super User

Hi @LeonardBagos-Working on dynamic datasets can be challenging, using the right tools and strategies can help manage these changes effectively. We can perform in Power BI - Power Query editor, along with tools like Python, R, and databases, can provide robust solutions to prepare and standardize your data before loading it into Power BI. 

 

Reference Link:

Power Query documentation - Power Query | Microsoft Learn

Power Query M formula language reference - PowerQuery M | Microsoft Learn

Hope it helps.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.