Forum Discussion
scheduled refresh is not working
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 ?
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.
3 Replies
nitishsh91Solution Supplier
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?
v-yadongf-msftCommunity Support
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.
- 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