Publish from Power BI Desktop for External Users

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! I show you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!!

Ross Couldrey

Distribute Power BI content to external guest users using Azure Active Directory B2B


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #ExternalUser #GuyInACube

[alonl]

Very helpful to have this feature. As an external consultant, I've been getting qualms from cost-sensitive clients for having to maintain an additional user for me on their domain. This will help in just dropping my projects on their tenant without having them buy an extra license.

[richardpearson]

Fantastic!! We've been wanting this for years at my company!

[jondell]

This was a huge help - I should have known to start with you rather than the forums! Answered my exact question. Thanks for the great consistent content!

[luiscabello]

Amazing video. This technique is also critical to let you connect your desktop Power BI Report (with no database) to a database at the external tenant. Thank you very very much!

[matthieumamet]

Thanks for the video !
Can they connect to the tenant datasets in live connection as well ?

[dessaleeyasu]

Hello Adam, I would like to thank you for your videos. It helps me a lot. And I just want to ask 1 questions could you please do a video on pause automated report a database refresh fails? Thanks 🙏

[williamwood]

Awesome stuff. Glad to see more B2B capabilities being added. Hoping that this might also make it possible for external users to build datasets from dataflows by connecting to datasets in an external tenant?

[arshamgheirati]

Thanks for that awesome hints, Can we publish that report to another workspace out of existing workspace? I am trying to connect the dataset as an external user to my workspace and create a combined report. is that doable?

[culpritdesign]

It should ask which domain you want to sign in to from the first login screen. They should also make an option to change domains.

[LiseHolck]

Hi Adam
Great video that helped a lot. I have a few issues, now that I have acess ;) - i want to setup automatic refresh and to publish some of the report as an app - is that possible?
Regards Lise

[canadian]

@adam: you show that the label is not automatically applied; I assume you can apply the label manually? Does it remain if the user re-publishes?

[AndresFelipeCastrillonValencia]

Great. Adam why conexion with salesforce reports works horrible? I trying to do ETL from dataflow and always apears a time out

[descrt]

When I change the underlying data column name to something else, my visual breaks and I get an "something is wrong with one of the field" error. This makes it necessary for me to change the entire visual again and all the formatting. Is there a way to just reassociate the drag and drop data field to the new data column name so that I don't have to go through the process of redoing the whole thing?

[samritigrewal]

I am using Windows 10 Enterprise 22H2, This is working in April '23 PBI desktop version but not in latest release of PBI desktop and due to this we can't upgrade with new PBI desktop version. Many users also reported this issue. For us it's important as we use external tenant a lot in our organization.

[Cander]

We had this need and I accidentally figured it out last week and documented it to send to our users. 😜

[mskikitv]

How do you make updates? Do I need to create another link?

[CNW]

Quick question for clarification. I'm coming from google data studio/looker studio. I make a lot of dashboards for individuals who don't want to pay for licenses which is why looker has been great. Is this possible with Power Bi if I have a premium license? It appears in their documentation that pro members can only share with pro members, but premium users can share reports with free users correct? Will these reports be live and update automatically from the dataset for them? Thanks!

[UberPWner]

Do you know if this could work for Storytelling in PowerPoint? My guest users want to use the Show in PowerPoint option from PowerBI but they can't get access to reports in PP.
In PowerPoint there is no Sign-In Options like in PowerBI where you can tell wchich organization you want to sign in

[Pride_Inoculum]

Do you need a premium version to share access or can you do this with a pro version?

It says on the pricing page that you can publish and share reports with the pro version.

[shaneanderson]

Interesting. We have been looking for this for some time. Unfortunately for us, it does not seem to work. We have two tenants, one in one (our) domain and one in another domain, to which we are B2B Guests. When I log into Power BI Desktop, it only asks me for my email address and then defaults to our domain... I do not see the "choose and account" dialog. I am never prompted, but rather seem to go directly into my local context. What am I missing? Seems like cached credentials, but I am not connected to a dataset at that juncture. What can I do to remove and cached credentials and get the login screens you are showing?