March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
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.
Please provide more details. Is this a Premium workspace? Did you share the app? Did they install the app?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
26 | |
15 | |
11 | |
10 |
User | Count |
---|---|
58 | |
52 | |
23 | |
14 | |
11 |