Forum Discussion
Golden Dataset from Dataflow - Access Permission Issue
Hi all!
I'm stuck in a framework that i've created.
Scenario:
On-Premisse Gateway (SQL SERVER) >>> 2 DataFlows (Facts and Dimensions) >> 1 Dataset ( from Dataflow)
2 useres - Pro Account
User "A" created the report at PBI Desktop. Published to Power BI Service and this is the Result:
Don't know for now if its the best practice, but, for now, works for me. (Aprecciate considerations)
So, whit user "A" i can read the content of report "Analise de Carteira - Produtos PF" as you can see
But, whit user B, nothing works. I've already gave access to Workspace (ADMIN), Dataset and reports and nothing works.
I think i'ts permission issue, to the Data Source created by PBI Service.
I Can't give any access to this Data Source.
Anyone can help?
Have you added user B as viewer to worksapce or given build permission through APP ?
Yes, i did it, but not works.
Changed the report to import data and it works. The problem were at Dataset accessing the Dataflow via Direct Query. Premium functionality and i have PRO users.
Thanks for the Answers
4 Replies
Is everything is in same workspace ?
If no then user will also require read access on golden dataset
Hi arvindsingh802 , thanks for the answer!
Now, i changed the solution to 2 workspaces.
- Master Workspace (Access only for User A )
- Dataflow
- Golden Dataset ( Access To User A and User B)
- Workspace X
- Dataset ( From Golden Dataset )
- Report
Gave build access to user B to Golden Dataset, but, even in BI Desktop i can't reach the Dataset, but i can see the Dataflow.
Have you added user B as viewer to worksapce or given build permission through APP ?
- Master Workspace (Access only for User A )