Forum Discussion
Power BI Embedded – DirectQuery visuals not loading in web app
Hi,
Thank you for the response. So the same error did occur in the workspace, but I fixed by refreshing the credentials/signing in again basically. As for the gateway, my SQL Server import data source has been configured correctly as I am able to access the report in the workspace.
I assume your first suggestion regarding the limitation might be the issue at hand here.
Community SupportHi yureed ,
There are certain limitations apply when working with DirectQuery for Power BI semantic models.
‘Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets or Azure Analysis Services model is not currently supported.’
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#working-with-a-composite-model-based-on-a-semantic-model
But also since you are getting the error, "An error occurred due to an on-premise server issue" hints that
your SQL Server Import data source or one of the DirectQuery datasets might need a gateway.
Make sure the gateway is:
Installed and configured correctly, Authorized for the dataset and Mapped data sources correctly for DirectQuery sources.
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!
Hi,
Thank you for the response. So the same error did occur in the workspace, but I fixed by refreshing the credentials/signing in again basically. As for the gateway, my SQL Server import data source has been configured correctly as I am able to access the report in the workspace.
I assume your first suggestion regarding the limitation might be the issue at hand here.