Hi,
if n users are using simultaneously 5 reports with 5 dataset (import mode) in premium capacity, is it different (perfomance wise) if those n users are using the same reports, but if the same reports share one shared dataset?
Should be considered Live connecions per second limit and memory usage? Thanks!
Solved! Go to Solution.
Performance should be the same. The measures, visuals, etc. used in your other reports are what causes load on the server when users are interacting with the reports.
What will improve is the refresh. 5 reports each with with their own dataset is 5 refreshes in the service, vs 1 report that is used as a live connection for 5 connected reports via a Live connection.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingPerformance should be the same. The measures, visuals, etc. used in your other reports are what causes load on the server when users are interacting with the reports.
What will improve is the refresh. 5 reports each with with their own dataset is 5 refreshes in the service, vs 1 report that is used as a live connection for 5 connected reports via a Live connection.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting