Forum Discussion
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 🙂
Hey Franck-SR ,
unfortunately, this is not possible at the moment.
This article: https://powerbi.microsoft.com/de-de/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/ mentions this "requirement" in the section: Behavior to note
I recommend creating an idea on ideas.powerbi.com or upvote an already existing one.
Regards,
Tom
2 Replies
- TomMartens
Super User
Hey Franck-SR ,
unfortunately, this is not possible at the moment.
This article: https://powerbi.microsoft.com/de-de/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/ mentions this "requirement" in the section: Behavior to note
I recommend creating an idea on ideas.powerbi.com or upvote an already existing one.
Regards,
Tom- Franck-SRNew Member
Hi Tom,
Thank you for your answer
I actually discovered this after my post 😞
I voted on ideas.powerbi.comRegards
Franck