Showing results for 
Search instead for 
Did you mean: 
Resolver II
Resolver II

PowerBi Dataset not showing in PowerBi Desktop



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?


Frequent Visitor

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.


Community Support
Community Support


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


Super User II
Super User II

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.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

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."


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.


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

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors