Forum Discussion
Does live connection load PBI node?
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?
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.
3 Replies
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
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.
