Forum Discussion

Johann_32's avatar
Johann_32
Advocate II
5 years ago
Solved

Shared Datasets & Live Connect

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

Dataflow
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    Hi Johann_32 

     

    If based on your example all your PBIX files are in import mode, there will be no additional load on the data sources when the Power BI reports are used.

     

    This is because all the queries are run against the Power BI datasets which is hosted within Power BI.

1 Reply

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Johann_32 

     

    If based on your example all your PBIX files are in import mode, there will be no additional load on the data sources when the Power BI reports are used.

     

    This is because all the queries are run against the Power BI datasets which is hosted within Power BI.