Forum Discussion
Underlying Error: OnPremiseServiceException
Ok, found out what was going on. To diagnose such errors go to the semantic model and try to write a DAX query that will access all the tables, eg.:
In my case it turned out that my workspace was missing an identity:
Resolve the error to see results
{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We are unable to refresh the semantic model because the model uses a data connection configured for Workspace Identity authentication, but the workspace has no identity, or the model owner does not have permissions to use the workspace identity. Please configure a workspace identity and make sure the model owner has Contributor (or higher) access to the workspace, or use a different authentication method."}}],"exceptionCulprit":1}}}
Going to Workspace settings -> Workspace Identity -> Create a workspace identity fixed the issue (just to be sure query again, refresh the model, republish the repo, etc.).
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum.
The OnPremiseServiceException usually means there may be problem with the gateway or the connection between Power BI Service and your data source (not the semantic model itself). You can try these steps:
- Make sure your on-premises data gateway is online and updated.
- Check that the data source credentials in the Service are still valid.
- Try republishing the report in case the copy in the Service got corrupted.
- See if there were any recent changes in the workspace or in the dataset’s gateway settings.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Community Support Team
1. How do I check if "on-premises data gateway is online and updated"?
2. "data source credentials" - if it was not the case wouldn't model refresh fail?
3. Tried it multiple time. I even tried creating new workspace - still no change.
4. I created new workspace, should I look into any specific settings?
Hi Anonymous ,
Gateway status – Open the On-premises data gateway app on the server → it should show Online. You can also check for updates there.
Credentials – Since the refresh works, credentials are likely fine.
Workspace settings – In the workspace, go to Dataset → Settings → Gateway connection → confirm it’s linked to the right gateway.
Thank you.In workspace settings I don't see Dataset:
Can you point me to some resources that would explain why the report should depend on on-premise gateway if the semantic model refreshes just fine?
If you mean data source - I have one data source, and here are the settings:
I also have dependency on another semantic model, but I don't have access to see it's settings - I can only read from it (which works fine in PowerBI desktop).
Ok, found out what was going on. To diagnose such errors go to the semantic model and try to write a DAX query that will access all the tables, eg.:
In my case it turned out that my workspace was missing an identity:
Resolve the error to see results
{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We are unable to refresh the semantic model because the model uses a data connection configured for Workspace Identity authentication, but the workspace has no identity, or the model owner does not have permissions to use the workspace identity. Please configure a workspace identity and make sure the model owner has Contributor (or higher) access to the workspace, or use a different authentication method."}}],"exceptionCulprit":1}}}
Going to Workspace settings -> Workspace Identity -> Create a workspace identity fixed the issue (just to be sure query again, refresh the model, republish the repo, etc.).