Skip to main content

Power BI

Needs Votes

Access Power BI dataset in Power BI Desktop using Azure AD B2B guest account

Vote (20) Share
Svante Gradén's profile image

Svante Gradén on 27 Aug 2020 08:53:12

I'm trying to access a Power BI dataset in Power BI Desktop using a Azure AD B2B guest account but I can only see datasets in my own organization.

As a consultant I often use my own Power BI Pro license to publish reports to customers but it's impossible to access Power BI datasets in customers tenants using Power BI Desktop.

Using Power BI Service I can access Power BI Datasets using my guest account.

Comments (3)
Svante Gradén's profile image Profile Picture

Shane Anderson on 18 Feb 2022 19:28:43

RE: Access Power BI dataset in Power BI Desktop using Azure AD B2B guest account

Hello - same here. We do not have Analysis Services and are not likely to purchase any time soon. Frankly, the fact that we cannot see data sets already created by us is annoying at best, and the only workaround of which I am aware is that we have to replicate another version of the data set. this nullifies the benefit of being able to reuse data sets. This need to be fixed. We have struggled with this for over two years.

Svante Gradén's profile image Profile Picture

Duncan Mitchell on 15 Dec 2021 00:01:26

RE: Access Power BI dataset in Power BI Desktop using Azure AD B2B guest account

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?

Svante Gradén's profile image Profile Picture

Martin Wille on 01 Nov 2021 18:53:06

RE: Access Power BI dataset in Power BI Desktop using Azure AD B2B guest account

I experience the same problem. The capabilities to create reports are limited for guest users, since they can't use PBI desktop when using a central/golden/decoupled dataset.