Using External Semantic Model in my report, not working when I publish report to PowerBi service

[Tom_Kowalski]

Hi there,

Hopefully someone can help me.

My report is using an external Semantic model for some of my visuals. I can connect to the external semantic model and connect tho the required tables within the external model. These tables are then visible in my list of tables on the far right hand side. Everything works fine in the PowerBI Desktop. But when I publish the report to a workspace in the PowerBI Service, the link to the external semantic model tables breaks, and the affected visuals do not work.

The result is all afected visuals return an error: "An exception occured due to an on premise service issue"

There is also an error across the top of the page which states that the data source is missing credentials and can not be accessed.

Has anyone got any ideas of how to fix this? Has someone else had this issue?

[hackcrr · Accepted solution]

Hi, @Tom_Kowalski 

Check Data Source Credentials:
After publishing, navigate to the Power BI Service and configure the data source credentials.
In the Power BI Service, go to the workspace where you published your report.
Find the dataset associated with your report. This is usually named after the report or model.
Click on the ellipsis (three dots) next to the dataset and select Settings.
Under the Data source credentials section, you will see a list of data sources. Locate the external semantic model data source.
Click Edit credentials. Depending on the type of data source, you may need to enter the authentication method, such as Windows, Basic, or OAuth2.

If your external semantic model is hosted on-premises, you will need to configure an on-premises data gateway.

Ensure that the authentication method used in the Power BI Service matches the method used in Power BI Desktop.

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly