Forum Discussion
You can't schedule refresh for this semantic model
First, I've looked through the posts with similar errors and used them to do my preliminary troubleshooting. As far as I can tell, I am not using any unsupported ones. I don't have a "Query1" so it's also hard to pinpoint what it's complaining about.
Error:
You can't schedule refresh for this semantic model because the following data sources currently don't support refresh:
- Data source for Query1
All of the sources are of this type:
Source = Excel.Workbook(Web.Contents("https://redactedmy.sharepoint.com/personal/redacted/Documents/Some%20Data/Some%20Data.xlsx"), null, true),
This report/semantic model was working up until 5/31. I have made some changes to the report and data source, but at this point, cannot remember if there's any one change that led up to this. I can only refresh the data using the Desktop app and subsequently Publishing the report again. The scheduled refresh is now failing every time.
I've found the issue.
There was a syntax issue 'DateTime.UtcNow()' which was supposed to be 'DateTimeZone.UtcNow()' in one of the steps in one of my Queries.
I wish there was a better error message for that case. It would have saved me a lot of grief.
What a needle in a haystack.
10 Replies
I've found the issue.
There was a syntax issue 'DateTime.UtcNow()' which was supposed to be 'DateTimeZone.UtcNow()' in one of the steps in one of my Queries.
I wish there was a better error message for that case. It would have saved me a lot of grief.
What a needle in a haystack.
How do you work out the actual issue that prevents the auto refresh?
My database has several tables, but I don't know where to start to identify what is preventing the "You can't schedule refresh for this dataset because the following data sources currently don't support refresh" message.
Is there a way to see exactly which table or formula is the issue?
Clicking "Discover Data Sources" yields nothing useful. Comes back empty.
- GilbertQ
Super User
Can you double check the link used does have access from the account in the data source settings?
GilbertQ , I do not see the following section on the semantic model as I do on other working models.
"Gateway and cloud connections" and "Data source credentials" are missing.
Broken semantic model:
Compared to a semantic model that is working for me. Also note that these two semantic models are pointing to the same Excel file on OneDrive for business.
- GilbertQ
It looks like the report you are showing does not have the semantic model but rather view the lineage to find the semantic model?
I still haven't fixed this. I can't pinpoint what caused this to break.
I also have the same problem
