You can't schedule refresh for this semantic model

[carlom_iptech]

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.

[stephchnva]

I also have the same problem

[carlom_iptech · Accepted solution]

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.

[Christian2000]

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?

[carlom_iptech]

I still haven't fixed this. I can't pinpoint what caused this to break. 

[GilbertQ]

Hi @carlom_iptech 

Can you double check the link used does have access from the account in the data source settings?

[carlom_iptech]

@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]

Hi @carlom_iptech 

It looks like the report you are showing does not have the semantic model but rather view the lineage to find the semantic model?

[carlom_iptech]

No, all I have shown so far is about the semantic model. But for the sake of showing the lineage.

One odd thing is although I can't see/change the Refresh settings for the model, I still get emails indicating the scheduled refresh has failed. 

[acarto]

I have the same exact problem. Is there any solution you've found?

[carlom_iptech]

Clicking "Discover Data Sources" yields nothing useful. Comes back empty.