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
Michael_Mertens
Resolver I
Resolver I

Build Permissions seem to be not sufficient

Hi,

I granted build permissions for a dataset / semantic model) to some users. If I give them a PBI Desktop file that has got a live connection to the dataset in it, they can use it. 
But they can't create a connection by their own. Get Data / Power BI Datasets is empty unless I provide much more permissions like modify the dataset.

Same with Excel. They can use an Excel sheet with pivot table connection that I provide but can't see any dataset when they use "Pivot Table from Power BI".

I don't find the exact explanations in the documentation. Can someone exlain or point me to the relevant documentation or a blog post?

Thanks & Regards
Michael

5 REPLIES 5
Michael_Mertens
Resolver I
Resolver I

It is a Premium workspace. Should that be a difference regarding the permissions?
Regarding "the app": There is no app. 

Maybe I should ask my question clearer: which permissions are necessary so that a user can see a dataset in PBI Desktop / get data / Power BI Datasets?

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
... only lists build permission which seem to be not sufficient.

The way it is supposed to work is that you publish the app, give your users read and build access to the app, then they (one time) register the app and can use the XMLA endpoints.

 

You can technically do all this via the workspace but that is not a recommended approach when you are on Premium.

Thank you, but apps and xmla endpoint are not the things I'm asking about here.
This document describes what I want to do https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
It just doesn't work like this in our capacity, so probably I should raise a support case.

give it at least a try.  In our experience that is how it works.  Once they register the app they can select the semantic model in their Power BI Desktop.

lbendlin
Super User
Super User

Please provide more details. Is this a Premium workspace?  Did you share the app? Did they install the app?

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!

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.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.