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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
varunjain
Employee
Employee

Please share your thoughts on the new in-place dataset sharing for Power BI datasets (preview)

Hit Reply and let us know what you think of the cross tenant in-place dataset sharing for Power BI datasets. To learn more about this feature, please visit this blogpost or our documentation.

 

Here are some areas that we'd like to hear about in particular:

  • Ease of use
  • Performance
  • Documentation
  • Authoring experience in Desktop
  • Governance and admin controls

Thanks - we look forward to hearing your feedback!

-Power BI B2B Team

60 REPLIES 60

No - I have not been able to fix.

Here it says: "Guest users can't use Analyze in Excel"

Maybe this change can allow this useful feature for external users also?

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-azure-ad-b2b#considerations-and-...
Thanks!

When you say you can see datasets in Power BI service, do you mean you can see it on home page in "From external orgs tab"? 

 

If yes, do you see "external datasets" tab in Desktop? 

no, there is nothing in the external tab in the datahub in desktop.

FloridaMan55051_0-1680053686795.png

 

Thank you FloridaMan55051. If you see "external data" tab in desktop and if you see shared dataset in PBI service (in "from xternal orgs" tab) then it means you are doing all the right things from your end as consumer.

 

Could you please review these sections to ensure:

1) External sharing is turned for the dataset shared with you https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-external-org-share-prov...

 

2) All the required tenant settings in consumer tenant are enabled: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-external-org-share-abou...

 

3) You have atleast "build" access to this dataset. Just read access will not allow you to access these in your desktop

 

4) Dataset shared does not fall under any limitation mentioned here: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-external-org-share-abou...

Parul, to my knowledge, I have checked off all those settings. I would love a teams session with you where I can show you that the settings are enabled.

@FloridaMan55051 @ParulBansal  
Ok, I got this to work. In the hosting Power BI Admin portal, just turn on this setting:

Guest users can work with shared datasets in their own tenantsThat's it. Now I can see it in the guest Desktop.
Enjoy!

that was it! thank you @iBusinessBI ! I may have missed that in the documentation or it wasn't there. 

Enjoy!

RevMel
Regular Visitor

This looks like what we need to provide Consultant access to our Datasets. Is this available On-premises. Where would I find the installation and configuration steps.

tamnm1601
Advocate I
Advocate I

The great part is that I can connect the dataset without it to be sponsored by the admin (in a big org, to get something sponsored contain bulky process). 

Another advantage is to able to connect to dataset perspectives but you should add this feature to the documentation (as I couldn't find it mentioned, I had to test it myself).

However, if I use composit model, it will create another dataset for the report which makes the duplication of dataset refresh while on the workspace.

FloridaMan55051
Advocate I
Advocate I

When I log into Power BI Desktop as the consumer, I can ONLY see the shared datasets. I can't find my other datasets to build a composite model. And, when I publish, it doensn't bring up my normal tenant workspaces. Please help. Thank you.

FloridaMan55051
Advocate I
Advocate I

I've went through many of the steps above, but am currently stuck with an authentication error when I try to see my datasets from an external org. Any ideas what may be causing this? thank you.

 

FloridaMan55051_0-1678368567825.png

 

Hi Floridaman, would you please expand the details and show what are the errors being displayed? As Parul mentioned below the most common limitation is the requirement of multi-factor authentication.

"From external orgs" tab will provide guest user access in provider tenant. "Authentication error" needs to be resolved by customer support team. But one of the common use case for this error is that provider tenant has MFA auth requirements. This features runs into limitations for MFA auth scenarios.

 

For "In place" sharing, you should actually go to "External Data" tab in Desktop. MFA auth scenario is also a limitation for "in-place" sharing capability.

Smudge
Regular Visitor

Hi, this sounds like a really valuable feature, but after 2 days of trying I've still not got it working. 😞

It would be great if I could get some help.

I've been following these Microsoft docs for enabling the feature.

 

The issue

I don't see the "external data" tab appearing in the data hub, neither in Power BI Desktop nor in Power BI Service.

 

My setup

  • I have two tenants, and I want to share a dataset from the first (the provider tenant) with the second (the consumer tenant).
  • I have two user accounts: one is an admin in the provider tenant and the other is a non-admin in the consumer tenant.
    • Both have full pro licenses (not trials)
  • I have a dataset in the provider tenant
    • This is in a pro workspace (I believe this because when I open the workspace settings, under the "Premium" tab, "License mode" is set to "Pro")

From looking at this licensing table I believe this licensing setup should be sufficient.

 

What I've done

  • Added my consumer user to the provider tenant as a guest
  • In the provider tenant (but not the consumer), in Admin Portal > Tenant Settings
    • Enabled "Guest users can work with shared datasets in their own tenants"
    • Enabled "Allow specific users to turn on external data sharing"
      • Explicitly given permission to the group my admin user is in.
  • For the dataset I want to share:
    • Enabled "External Sharing" > "Allows external users to discover, connect to, and work with this dataset within their own Power BI tenant."
    • Shared the dataset with my consumer tenant user
      • Enabled all permissions
    • Made my consumer user an admin of the workspace containing the dataset
  • Downloaded Power BI Desktop
    • Enabled all preview features
    • Restarted (both the app and my PC) (several times each)

 

According to the docs, after doing these steps, when logged into my consumer account, I should see the shared dataset in Power BI Desktop / Service > Data Hub under "External Data". But the "External Data" tab does not exist, and I don't see the datasets under "All".

 

Do you have any idea what the problem could be?

 

Other notes

An aside: on the doc for guest users it's unclear whether the external data will show up in Power BI Desktop or Power BI Service or both. It implies that downloading the Desktop app and enabling preview features is a requirement to work with external data, but in the "Access shared datasets" section it says, "In your tenant, go to the data hub in Power BI service," implying that the data will show up there. This is confusing, because I doubt whether having preview features enabled in your desktop app will affect what appears in the Power BI Service. Is it a mistake? Otherwise, the documentation is very clear and concise!

Hi - thank you for your message. Can you please confirm the following:

a) In the provider tenant, are all the required settings listed here enabled? 

varunjain_0-1678300636517.png

b) Is the consumer a registered AAD guest user?  You mentioned you "Added my consumer user to the provider tenant as a guest" - did the consumer accept the guest invitation by clicking on the email that is generated when a user is added? Note the user needs to be registered AAD user in order to access external content.   

c) In the consumer tenant desktop, are the following options enabled? 

varunjain_1-1678300839855.png

 

 Note that for in-place dataset access, the consumer needs to access it on their desktop. In-place access is not currently available in the service. 

Hi Smudge,

 

Could you please check and see if you have "From external Orgs" tab on your PBI service homepage? This tab lists everything that you have access to as guest user. Datasets shared with you by another tenant should come up in "From external orgs" tab as well. This is just to confirm that you really have access to this dataset as guest user. "From external orgs" tab will not give you same experience as "External data" tab. 

 

I would also highly recommend going through our limitations section to understand in what scenarios the functionality will not work: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-external-org-share-abou...

Thanks ParulBansal and varunjain for your responses.

In the end we went for a different solution which didn't require external data sharing.

 

But for others who end up reading this I'll respond to the questions in your messages:

Varunjain:

a) All those settings were enabled

b) The consumer user did accept the invite to the provider AAD, so yes, they were a registered AAD user.

c) Those settings were enabled on the consumer Power BI desktop app.

 

ParulBansal:

Yes, it was possible to see datasets in `From external orgs`, on the PBI service homepage.

 

My best guess is that data-sharing didn't work becuase the provider AAD wasn't premium. I believe this was the problem because there is a requirement, "The provider tenant needs to turn on the Trust multi-factor authentication from Azure AD tenants option," on this doc. I seem to recall that this setting wasn't applicable because the AAD wasn't premium. Perhaps this was the issue?

 

Paudie81
New Member

Hi,

 

I have set up in place dataset sharing with an external company. The person I am working with in the external company can see the shared datsets when they log in to their Power BI cloud tenant. However they cannot see the datasets in their Power BI desktop app.

They have 

  1. Select the checkbox next to the DirectQuery for PBI datasets and AS option

  2. Select the checkbox next to the Connect to external datasets shared with me option.

They can see the External data tab, however no dataset appears here. Why would this be?

 

Thanks,

Padraig.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.