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 Neeko,
I think I followed the documentation.
- I did enable the 'Allows external users to discover, connect to, and work with this dataset within their own Power BI tenant. ' setting.
- Also enabled 'Connect to external datasets shared with me'
- user has direct access with all rights
still I do not see the dataset inside power bi desktop.
is there some tenant setting missing?
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 Anonymous ,
thanks again for taking time to respond. I asked my tenant admin to have a look at the settings.Hi whereismydata ,
Has your problem been solved? If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out. Thanks in advance.
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 Anonymous
thanks for sharing the tenant setting screenshots. I provided them to our tenant admin and it seems that one settings in not enabled (the "Allow guest users to work with shared datasets in their own tenants" setting)
but I'm curious. The other setting is enabled and I'm able to select the external sharing in the dataset settings. Also I am able to give permissions to my test account.
So, is there a way to analysize data in excel with the given setup? Somehow I can not force excel to use the tenant url to connect to the dataset
In new powerBI Desktop, we can't see Direct Query for powerBI Datasets and AS option.
Also we are able to see dataset in powerBI Desktop but getting
and error as "Live connection is not vaila le for accessing models in an external organization, Directquery connection is require"
i am not sure , what it means.
can u pls help here.
Anonymous