Forum Discussion
Error with Composite Model with DirectQuery to Analysis Service for B2B user
Thanks for the suggestion. In our case, we maintain the primary model and so the customer would need to connect directly to it so when we make changes, they would get those as well. I talked to Microsoft support and what are trying to do is not possible because of restrictions placed on between tenants. We are going to try to create another user in the tenant with the published model to see if that works. Support indicated that others have requested the ability to do what we were trying to do and that it is possible this capability may be added later.
Hi drreese -Export the semantic model as a .pbix file and publish it in a workspace accessible to the B2B user. This avoids tenant hopping.
Or, consider creating a composite model in a separate workspace with imported or dual-mode tables that reference the original model (though B2B access will still be a challenge here).
some reference links:
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Try reproducing the same scenario using a user within your tenant. If this works, it confirms the issue is specific to B2B tenant resolution or permissions.
Thanks for the suggestion. In our case, we maintain the primary model and so the customer would need to connect directly to it so when we make changes, they would get those as well. I talked to Microsoft support and what are trying to do is not possible because of restrictions placed on between tenants. We are going to try to create another user in the tenant with the published model to see if that works. Support indicated that others have requested the ability to do what we were trying to do and that it is possible this capability may be added later.
Hi drreese,
Thanks for the update earlier. Just wanted to check were you able to create the new user in the tenant with the published model? Did that help fix the issue?
If you found any other solution or workaround, please do share it here so it can help others facing the same problem. Also, if you haven’t already, consider upvoting the related feature request in the Fabric Community to help Microsoft prioritize it.
Thanks & Regards,
Prasanna Kumar
We did create a user in the tenant and we were able to create a composite model using Direct Query. I was able to publish it to another workspace by placing the new data in OneDrive and adding it by choosing Web as the data source. Once published, the connection to the model broke because of user permissions, but I was able to edit it in the service and update credentials to get the published version working.