Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I have 2 questions regarding performance of a report in the service that is being used simultaneously from up to 20 users at the same time. The connection mode of this report is a Direct Query mode to 4 tables (from avarage to big).
Questions:
I know that this is something that needs to be tested that's why I am wondering if someone has done it already.
Thanks in advance.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Solved! Go to Solution.
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.
The usual database locking rules apply. Table locks, row locks, optimistic vs pessimistic locking etc.
All you do is add another layer between the user and the data source.
It sounds like you took me to another level of discussion.
All I care about is how the report would act when 20 users are visualizing it at the same time. I know for Import mode wouldn't be a problem but I wonder for DQ when the data source is updating at the same time
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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.
Using views will likely make it worse! What do you mean? Like how worse if I still use DQ to connect to that view?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.