Forum Discussion
Cannot load model error on Report connected to Premium XMLA endpoint in Premium
Hi Anonymous this is actually a known issue. It is documented here: https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools#power-bi-desktop-in-live-connect-mode.
You will be happy to know that we are working on it and should have something ready soon.
Hi, is this still an issue?
In the scenario, when a PBI Desktop Report is authored by a B2B Guest, they have to connect to the external tenant's PBI Service Datasets using XMLA over Analysis Services (only option because they can only see their home tenant PBI Datasets when trying to get data from PBI Datasets), the reports work fine until they are published to the external tenant service.
Is there any alternative for B2B Guest Desktop authoring and publishing against existing PBI Datasets in another tenant?
Just to answer my own query here, a workaround which I managed to figure out
- Use a local tenant account to author a blank report using "Power BI Datasets", connect to the same service Dataset and save the .pbix
- Rename the pbix to .zip, open and extract the "connections" file
- Rename the guest-created report .pbix to .zip
(this file is using "Analysis Services" connection to XMLA) - overwite the "connections" file in guest .zip in [3] with file extracted in [2]
- Revert the guest-created report .zip to .pbix
Now when the guest uploads their .pbix file it will be using a "Power BI Datasets" datasource.
PS: this confirms that the limitation of a guest authoring reports against external tenant Power BI Service Datasets is simply a UI limitation of PBI Desktop; PBI Desktop should simply ask which tenant to connect to and generate the correct "connections" file