Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
s2mcl
New Member

External User (Azure B2B) - build Report from shared dataset in Power BI Desktop

Hi,

 

I've been scanning through a load of the posts around this topic and what is supposed to be possible.

 

The scenario is that we have a Power BI tenant and have Power BI Pro licenses.

I have a workspace which is in Premium Capacity.

 

I have turned on all of the external guest user sharing options on the Power BI tenant admin settings.

 

I have invited users using Azure B2B as guest users to my AAD. These users all have Power BI Pro licenses.

 

I have added these users as Contributors to my workspace.

I have added explicit share links and direct access to the B2B guest users.

 

When these users follow the link - they can see the datasets and the reports in the web portal.

If they don't follow the link, and login to app.powerbi.com they don't see these, and can't access direct URL links.

 

I managed to establish (with the help in this forum) that in Help > About Power BI shows they are logged into two different tenants in these scenarios. 1. Ours when they have the sharing link, 2. Theirs when they don't

I'm all good with that.

 

However - what I want is for them to use a shared dataset and create their own reports in Power BI Desktop

Those datasets never become available in Power BI Desktop - as I assume it thinks they can't see the content?

 

I read this - https://learn.microsoft.com/en-us/power-bi/guidance/whitepaper-azure-b2b-power-bi

Which has some diagrams that show they should be able to access the datasets using Power BI desktop.

s2mcl_0-1676994364252.png

 

But then found this - https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b#considerations-and-...

which describes a limitation...

s2mcl_1-1676994399973.png

 

So - question I have is - which is it? Is there a limitation, or is is possible?

 

 

1 REPLY 1
rka_sd
Frequent Visitor

I suggest you read this article: 
https://powerbi.microsoft.com/en-ie/blog/introducing-cross-tenant-power-bi-dataset-sharing/

We had some additional challenges for someone else. We created the guest user in our Azure AD. But we also had to add Reports Reader role to that guest user. After this, the person could access our externally shared datasets on the workspace he were added as a member. 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.