cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Johann_32
Frequent Visitor

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

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User II
Super User II

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.