Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
thyagorc
New Member

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:

thyagorc_0-1658797639365.png

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 

thyagorc_1-1658797773906.png

But, whit user B, nothing works. I've already gave access to Workspace (ADMIN), Dataset and reports and nothing works.

thyagorc_2-1658797878692.png

 

I think i'ts permission issue, to the Data Source created by PBI Service.

thyagorc_3-1658798036471.png

I Can't give any access to this Data Source.

 

Anyone can help?

 

2 ACCEPTED SOLUTIONS

Have you added user B as viewer to worksapce or given build permission through APP ?


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

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

View solution in original post

4 REPLIES 4
arvindsingh802
Super User
Super User

Is everything is in same workspace ?

If no then user will also require read access on golden dataset


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

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.

thyagorc_1-1658925573781.png

 

 

Have you added user B as viewer to worksapce or given build permission through APP ?


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.