Forum Discussion
One report for multiple users simultaneously
If you use Direct query then all optimizations need to be done at the data source. Index maintenance, statistics up to date etc. You will also want to tell the db owners to expect many concurrent connections.
Using Views will not improve things, it will likely make it worse.
If, however, you switch to Import Mode then all these problems go away magically as the data is cached in the Power BI service and it doesn't really matter any more how many users are looking at it.
If you use Direct query then all optimizations need to be done at the data source. Index maintenance, statistics up to date etc. You will also want to tell the db owners to expect many concurrent connections.
Using Views will not improve things, it will likely make it worse.
If, however, you switch to Import Mode then all these problems go away magically as the data is cached in the Power BI service and it doesn't really matter any more how many users are looking at it.
