scheduled refresh is not working

[Yani4ar2]

Hello everyone , so  In one of the source data (.xlsx file) column name Name2 was renamed. After that scheduled refresh is not working , what can be a solution ? 

[v-yadongf-msft]

Hi @Yani4ar2 ,

Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.

Best regards,

Yadong Fang

[v-yadongf-msft · Accepted solution]

Hi @Yani4ar2 ,

Data refresh on the Power BI service will fail when the source column or table is renamed or removed. It fails because the Power BI service does not also include a schema refresh. To correct this error, a schema refresh needs to happen in Power BI Desktop and the dataset republished to the service.

Schema refresh is in Power Query -Home -Refresh Preview.

Please note: A renamed or removed column or table at the data source will be updated with a schema refresh in Power BI Desktop, but it can break visuals and DAX expressions (measures, calculated columns, row level security, etc.), as well as remove relationships, that are dependent on those columns or tables.

For more information, please refer to: Data refresh in Power BI - Power BI | Microsoft Docs

Best regards,

Yadong Fang

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

[nitishsh91]

Hi @Yani4ar2 

What error are you seeing in dataset refresh history, can you share that so that it gives more detail on the issue that you are facing. Also please confirm what is your workspace type where this dataset is hosted standard or premium workspace?