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