Forum Discussion

po's avatar
po
Post Prodigy
5 years ago

Security on dataflow access/use

Hi,   Have power bi premium and can see access to dafalows currently disabled.     Woudl like to turn on access to this but only to selecteed users, such that only certain users can create and u...
Need Help
jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
5 years ago

Dataflows are not a data warehouse, they're an ETL tool.  Remember dataflow output is stored in CSV files behind-the-scenes, so anything consuming from it will have to read-in that whole CSV file and process it with the Power Query engine--there's no querying as if a database, or query folding from the client.

 

There is the Enhanced Compute engine, which caches the data from CSV into a SQL store (again, behind the scenes--you have no visbility or control over how this works) but the SQL store will only be used by other dataflows in Premium Capacity when those sources are used as Linked Tables in the dataflow.  Power BI Desktop will always use the CSV-store.

EDIT: https://ssbipolar.com/2018/11/22/positioning-power-bi-dataflows/

po's avatar
po
Post Prodigy
5 years ago

Thanks agains for info.

 

We have recently got power bi premium - had pro before.

 

If we create a premium workspace with dataflow to say pull in objects can existing non-premium workspaces use the dataflow in the premium workspace?

 

 

 

Thanks