Dynamic Excel Dataset

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.

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.