Forum Discussion
Using a semantic model
Hi user34567890987 ,
sorry for the delay in response!!
This looks like a composite model / DirectQuery connection to another semantic model, rather than a Build-permission issue. Since the visuals work in Desktop but fail after publishing with OnPremiseServiceException, check the following as suggested above :
- Make sure the tenant setting Allow DirectQuery connections to Power BI semantic models is enabled.
- In the published semantic model, check Settings -> Gateway and cloud connections / Data source credentials and ensure all connections are configured.
- If the source semantic model ultimately uses an on-premises data source, verify that the On-premises Data Gateway is online and correctly mapped.
- Also confirm both models are in the same Power BI tenant.
Microsoft specifically notes that composite models based on another semantic model require all credentials to be set in the Power BI Service
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
Thanks!!
Super UserCan you also confirm that the other Semantic model does not have low level security applied to it and that is why you might be getting the issue? If you could please share a screen shot of your error.
The other semantic model is in the same security level as mine I am assuming. I couldn't upload a screenshot, but just typed out the error details in a different reply
