Underlying Error: OnPremiseServiceException

[tomasz-grobelny]

Hi all,

When trying to view my report in PowerBI Service I get the following error:

An error occurred in Power BI Premium backend services. Please see the error details for additional information.

In details on visuals I get this:

Underlying Error: OnPremiseServiceException

plus a number of guids (that probbaly won't help on a public forum).

The underlying semantic model refreshes just fine. I am 90% sure the report was working earlier today. Also on PowerBI desktop all works fine.

Any idea how do I approach solving the issue?

[v-menakakota]

Hi  @tomasz-grobelny , 
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  

[tomasz-grobelny]

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?

[v-menakakota]

Hi @tomasz-grobelny ,

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.

[tomasz-grobelny]

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).

[tomasz-grobelny · Accepted solution]

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.).

[v-menakakota]

Hi @tomasz-grobelny  ,
Thanks for reaching out to the Microsoft fabric community forum. 

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[GeraldGEmerick]

@tomasz-grobelny You can check for whether there is a service issue or a known issue here - Microsoft Fabric service status

If it is not listed, then you can open a support ticket.