Does live connection load PBI node?

[Anonymous]

When creating a report using live connection to PBI dataset stored in premium capacity workspace, am I right that it works similar to Direct Query and too many simultaneous queries to the dataset (for example from different analysts) may cause high load on PBI node? Or live connection doesn't affect on PBI node performance?

[MikeJohnsonZA · Accepted solution]

Yes, this creates something similar to direct Query but against the underlying Tabular data set.

Tabular is very good at dealing with concurrent requests (Better than something like SQL) so the additional load should not usually be a problem unless you have an inefficient model and queries or have a lot of concurrent connections. (what a lot means depends on the size of the models and the capacity)

bottom line is that there will be an impact but it should not be significant.

[Anonymous]

Ok, I guess I just need to try and monitor the node performance. My goal is to optimize datasets in PBI service to avoid storing of similar data, but at the same time to make sure it won't decrease report performance in web.

[amitchandak]

@Anonymous , If the live connection is on SSAS, then it like a direct query.

But if it on power bi dataset, then it depends on that

you can also check this blog -https://radacad.com/live-connection-when-power-bi-comes-hybrid