Using a semantic model

Hi user34567890987​ ,

Could you review the suggestion provided above and let us know if you have any additional questions, we are happy to address. 

Thanks!!

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 :

1. Make sure the tenant setting Allow DirectQuery connections to Power BI semantic models is enabled.
2. In the published semantic model, check Settings -> Gateway and cloud connections / Data source credentials and ensure all connections are configured.
3. If the source semantic model ultimately uses an on-premises data source, verify that the On-premises Data Gateway is online and correctly mapped.
4. 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!!

Hi user34567890987​ 

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

Hi user34567890987​ 

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.

Check these below settings :  reference : Power bi Semantic model issue | Microsoft Fabric Community

1. Confirm the tenant setting allows DirectQuery to Power BI semantic models. In the Admin portal, turn on Allow DirectQuery connections to Power BI semantic models. If disabled, connections to a published semantic model as a source will fail. Doc: Admin setting.
2. Make sure the source semantic model does not discourage chaining. If the source model was published with the option to discourage DirectQuery connections, new composite connections are blocked. Clear that option and republish the source if needed. Doc: Discourage DirectQuery connections setting.

Hi user34567890987​ 

Could you please send a screenshot of the area experiencing so we can help you with that?