Forum Discussion
Sharing dataset with external users
Hi whereismydata ,
Please check that the following steps are followed:
- On the Power BI service, if you want to share datasets with guest users, you must enable these two settings:
- Then you can open the dataset, select the Share button, and enter the guest user.
- Within the dataset Settings, go to the External sharing section, and enable the Allows external users to discover... option (Note if the customer does not see the External sharing section, the Allow guest users to work with shared datasets in their own tenants tenant setting may not be enabled)
- To access the shared dataset, you must use Power BI Desktop.
- Turn on preview features: DirectQuery for PBI dataset and AD and Connect to external datasets shared with me
- Get data from Data hub and select the new tab that appears if the user is a guest in another user's tenant named External data
- Find the dataset and Connect to it, select item and Submit to create the connection
- Dataset appears and can be used. You can also add another dataset to include in report to create the composite model
- At this point, the dataset is the same as any other dataset that can be used to create a report in the Desktop or Service.
In addition to this there are some restrictions:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi whereismydata ,
According to the documentation, you can use guest users from different tenants to share datasets with guest users on their own tenant using Azure Active Directory guest accounts. To help allow guests to log in to Power BI, please provide them with the tenant URL.
To enable sharing datasets with guest users, you must enable the "Allow external users to discover and use this dataset" option in the dataset settings.
To access the shared dataset, you must use Power BI Desktop and turn on the Preview feature: PBI Dataset and AD's Direct Query and Connect to External Dataset Shared with Me.
If you encounter errors when connecting to a Power BI dataset using the direct query mode in PBI Desktop, you can turn on the "Allow XMLA endpoints and use local datasets for analysis in excel" switch in the tenant settings.
It is also important to note that linked sharing is not yet supported for external users, but users can still share with external users using direct sharing.
Please refer to the following documents for more information.
Distribute content to external guest users with Azure AD B2B - Power BI | Microsoft Learn
Share B2B datasets with external guest users (preview) - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.