Forum Discussion
Using a semantic model
- 18 days ago
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!!
The fact that both semantic models are in the same workspace and you have Build permission doesn't necessarily rule out a composite model/chaining configuration issue. I'd first check the two settings mentioned above, but the exact publish error would be useful to determine whether it's a permissions, chaining, or model configuration issue.