Forum Discussion
Anonymous
5 years agoNot applicable
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 (fo...
- 5 years ago
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.
amitchandak
5 years agoSuper User
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