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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Yani4ar2
New Member

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 ? 

1 ACCEPTED SOLUTION
v-yadongf-msft
Community Support
Community 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.

vyadongfmsft_0-1662446649264.png

 

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.

 

View solution in original post

3 REPLIES 3
v-yadongf-msft
Community Support
Community Support

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
Community Support
Community 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.

vyadongfmsft_0-1662446649264.png

 

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
Solution Supplier
Solution 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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors