Semantic Model refresh disabled - report in different workspace

Question

Is there a way to ensure scheduled refreshes work when the semantic model is in one workspace and the report using it is in another. I saw a similar question last year but it didn't get much traction. I am also in disbelief if this is truly the way Power BI works.

Our setup:

Workspace A
- contains Semantic Model
Workspace B
- Contains Report which uses Semantic Model as a data source
Report is set up to have a daily refresh, so Semantic Model is being touched daily
Looking at the activity log history, there are instances of View Report by users within the past 60 days

Despite the activity on Report, I got a notice that "Your scheduled refresh has been paused" due to inactivity. "No one has viewed dashboards or reports built using this semantic model for two months."

I understand that I can set the model to refresh again, but why do I need to manually do that every two months when it has activity on a downstream object? This feels like a bug, but I imagine someone is going to tell me this is intended.

aj1973 · Answer

Hi&nbsp;cwollett&nbsp;Technically this could be a bug in the dataset or more likely a failure as shown in here&nbsp;Maybe, before rerunning the refresh in the service it is wiser to open the Power Query of the dataset in the Desktop to identify where the failure is coming from.

cwollett · Answer

Thank you for your reply. We are definitely having the issue shown in the first note from your screenshot, not the second. Reasoning:There are no errors in either the semantic model or the report - I verified this by opening the PBIX of both and they refresh with no errors.Both the semantic model and the report have been refreshing for months with zero issues - so we are not disabled due to consecutive failures.The message we received over the weekend was that inactivity alone was the cause of the refresh being disabled.The only reason I can think that this would be happening is that the report that gets visited is in another workspace. So if I visit the report, it doesn't know to kick off the refresh of the model in the other workspace? It didn't, by the way, I visited the report and it did not kick off the refresh despite the note in the screenshot saying to resume, visit a report built on the model.

aj1973 · Answer

Separating reports from its dataset in 2 different Wrokspaces is a healthy move according to Power BI best practices. A thin report is connected to its Dataset in a Live Connection Mode and the Queries are sent to the dataset as its data source and nothing else therefore visiting the report does not kick off the refresh of the dataset unless the dataset is in a DQ mode(which is not your case).&nbsp;The messages from Power BI service can sometimes be confusing and you will have to troubleshooting yourself.&nbsp; &nbsp;

v-priyankata · Answer

Hi&nbsp;cwollett&nbsp;aj1973&nbsp;Thanks for the inputs.
I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.
&nbsp;

cwollett · Answer

Hi&nbsp;v-priyankata&nbsp;Unfortunately the information provided is not a solution.&nbsp;aj1973 mentioned that it is common to have semantic models and reports in separate workspacesWhen we do this, our underlying semantic models do not refreshThe only error message we get is "due to inactivity" - which does not make sense as there are reports being used on top of the data model within the 60 day window.

Forum Discussion

Semantic Model refresh disabled - report in different workspace

Related content

Cross workspace semantic model access

Binding a report with a semantic model in a different workspace

Updating a Semantic Model to use a different Workspace

List of Large Semantic Model within different workspaces

How to reconnect Semantic Model in different Workspace?