Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to Solution.
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
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.
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 ?
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 32 | |
| 18 | |
| 14 |