Hello,
The context :
I have a PBIX in Mixed storage mode.
- Two DirectQuery connections to 2 different datasets
- Credentials : "Microsoft Account"
- level of confidentiality : Professional'
- A Dataflow in import
- An Excel file imported from Sharepoint
- Publish in a Premium Workspace by User
The problem :
In PowerBI Desktop everything is fine.
When I post to the service and log in with my account, everything is fine.
Now, I want to share this report with a specific user (for whom I took the PRO + PPU license)
But I don't want this user to be able to build another report with this dataset, nor the shared one. I just want him to use my report as is.
So, I created a sharing link specific to this user for which I unchecked:
- Allow share the report
- Allow create content with the data associated with this report
When I connect with the account of this user, I have crosses everywhere except on the components which display data coming from the imports
While looking on the net, I saw that it was necessary to put the right "Build" on the datasets to which I am connected in DirectQuery ....
Indeed, if I do that, the user can read my report correctly, but suddenly he also has the possibility of seeing the datasets and creating a new report that would consume these datasets !
If I change the rights and I just put the right to "READ", the crosses are back !
Do you know of a way around this problem? Can we disable for a user the right to create reports on a dataset for which he has the Build right.
Thank you in advance 🙂
