Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Auto update failure for Dataset

Submitted by Anonymous on ‎08-02-2021 10:54 PM

Hello,

 

I have a dataset named Tier2_weekly, when refreshed and publish through Desktop application it works fine but when auto refresh is scheduled, it gives this error - not sure how to address this. Please help

 

Data source error:The 'Age' column does not exist in the rowset.
Cluster URI:WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:764f9267-775c-4138-9aaa-2fa353473256
Request ID:1aed9a2c-a19e-ad17-ca3b-1ac26a7b4b42
Time:2021-08-03 05:44:58Z

 

Data Refresh at 11:14:51 is for the Dataset uploaded and it fails. The dataset which is used through PowerBi desktop doesn't give this error.

 

 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎08-03-2021 06:51 PM

Hi @Anonymous ,

Sometimes this error is because a column was moved, renamed or removed in the original data source.

 

As far as I know, power query will cache the first time process result data structure into the query steps. If you do any changes to your data structure(power query or database side), they not auto-sync to each step and you need to manually fix them.

 

You can try to clear the cache in Power BI Desktop, re-open the file and refresh it to check whether the column is there. If it is, re-publish and see if it is now there on the Service side.  Refresh on the Service side and see if there is an error.  If there is an error still after all of that, then go backto desktop and save a renamed version of the report and publish that and see if the renamed version works.

 

Best Regards,
Community Support Team _ Yingjie Li

 

Idea Statuses