Forum Discussion
Sharing dataset with external users
- Anonymous3 years ago
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 ,
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.
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