Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

PowerBi Dataset not showing in PowerBi Desktop

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!

8 REPLIES 8
Anonymous
Not applicable

Hi everyone. I notice that if i click the "Get Data" button on the visuals pane the option shows up, but if I click "Transform Data" and from Power Query I click "New Source" it doesnt show. 

Same for me , It works now. Thank you for the comment 

Anonymous
Not applicable

Hi There,

 

I have been trying to enable self service reporting for the business users (Free Users). My scenario is to publish a master dataset in a workspace and business users should be able to use that dataset and do light weight oprations like using fields to build some visuals in Power BI services itself.
So I tried adding them in a premium workspace with contributor access where i have published a the dataset. With contributor access it works as expected but the only turn down is RLS doen't work above Viewer.

When I tried with viewer access with build permission on the dataset, it shows everything shared but lt does'nt let a end user use the dataset to build a new report.
Please let me know if there are any workaround.

 

Thanks,

Shiva

Anonymous
Not applicable

Hi @Anonymous 

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
Community Support
Community Support

@Anonymous 

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
Super User
Super User

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

Anonymous
Not applicable

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

Facing the same issue. Was anyone able to resolve it?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.