Forum Discussion

Franck-SR's avatar
Franck-SR
New Member
5 years ago
Solved

Share report with Direct Query

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  🙂

 

2 Replies