PowerBi Dataset not showing in PowerBi Desktop

[CristianAv]

Hi

I have created a PowerBi Dataset and Report in a Workspaces of the PBI Service (With Premium capacity).

I'm testing it with two different users:

a) User with PRO licence and added as a Member of the Workspace

This user can see the Report in the service and use the PBI Dataset in the PBI Desktop. So it's working as expected

b) User without pro, added as a Viewer of the Workspace, with build permission added for this dataset.

This user can see the Report in the service, but when I try to use the PBI Dataset in PBI Desktop, the dataset is not being show.

With this user, I've tested the "Analyze in Excel" and it worked.

What could be wrong?

Thanks!

[LeoSugianto]

Hi @CristianAv 

Have you created a ticket for this? If so, please give the link so I can add my thumb for this as I'm experiencing similar issue with Build permission.

@V-pazhen-msft question related with this, if a User with Pro license, NOT having access to the Workspace (not added as Member or Contributor or Viewer etc), but given build permission for the dataset.
Is it possible for this user to see the PBI Dataset in PBI Desktop?

The reason I'm asking is that I'm trying to make the user to be able to create a report (both in PBI Service and PBI Desktop) based on the shared dataset inside a "Master Workspace", but I don't want them to see this so-called "Master Workspace", let alone give them the ability to edit anything inside this workspace.

Currently, I can only make it work using a) User with PRO licence and added as a Member of the Workspace.
Giving them Member access means they can do lots of things including modify or delete the dataset completely, which is a risk for IT.

Thanks,
Leo

[V-pazhen-msft]

@CristianAv 

For test B, it used be worked for me, but this time I had the same issue. I can only see the datasets from my workspace in Power BI Desktop. I was only able to get the dataset using Power BI Service: Get data => Published dataset. 

I would suggest  you to create a support ticket or post in the  issue forum for a quick response. 

Best regards

Paul Zheng

[GilbertQ]

Hi there

A user a Free license is not able to create Power BI reports of datasets. They can only view existing data.

If you need a user to create reports they will need to get a Pro license even if on Premium Capacity.

[CristianAv]

Hi Gilbert

Are you sure? I wonder because I keep doing some test, and I've added a free user with the "Member" role in a Premium Workspace, and this user can actually access to the Shared Dataset from PowerBi Desktop! (And the user don't even have the Trial Pro license).

In this link, from the microsoft documentation, they say:

"If you're a free user, you only see datasets in your My Workspace, or datasets for which you have Build permission that are in Premium-capacity workspaces."

https://docs.microsoft.com/en-us/power-bi/service-datasets-discover-across-workspaces

Also, in this microsoft post, they say that with Viewer Role and Build permission, an user can use Analyze in Excel or export underlying data from the datasets in the workspace.

https://powerbi.microsoft.com/en-us/blog/announcing-the-new-viewer-role-for-power-bi-workspaces/

So i'm confused about how does this shared datasets works..