Hello,
we are currently thinking about allowing the use of Shared Datasets. I would have aquestion about this..
As an PBI Administrator, I saw the option "Allow live connections" in the Admin Tenant settings.
--> Is using a shared dataset from the power bi service always a "live connection"? If yes, then my question would be what this means in terms of performance and load for the datasource?
We only allow the use of dataflows as "system-based" datasources in our organization. These dataflows are import mode, only. No connect to any other source than local source is allowed.
This means, a shared dataset can only be connected whether to a local source like csv or to a dataflow.
Can you confirm that this means we do not put any load on the database where the data comes from? Or does the live connection really "trigger" the dataflow to do a query (similar like Direct Query) on the database?
Thank you
Best Wishes,
Johann
