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.
I am trying to understand the performance impact when a power bi report has a live connection to ssas tabular cube (source is oracle DB), when data gets into millions of rows per partition over time
The tabular cube is refreshed every day, so when power bi reads from the tabular cube, my understanding, because of the in memory feature of both ssas tabular and power bi engines, the performance won't suffer with increase in data because when power bi reads from the cube, we are not hitting the source database (oracle)
Is my understanding correct, and what happens if there are like 100 users logging into power bi using this live report ? how will the performance be /
Solved! Go to Solution.
HI @Anonymous,
In fact, the operations of different users will be merged into the same session to interact with the database. They will also affect the database performance and usage if users interact with reports frequently. Perhaps you turn on the cache feature the reduce the request amounts:
Data refresh in Power BI - Power BI | Microsoft Docs
In addition, you can also take a look at the following links to know more about different connection modes and trace these requests.
Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD
SQL profiler to trace request sessions from power bi.
SQL Server Profiler - SQL Server Profiler | Microsoft Docs
Monitor report performance in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
HI @Anonymous,
In fact, the operations of different users will be merged into the same session to interact with the database. They will also affect the database performance and usage if users interact with reports frequently. Perhaps you turn on the cache feature the reduce the request amounts:
Data refresh in Power BI - Power BI | Microsoft Docs
In addition, you can also take a look at the following links to know more about different connection modes and trace these requests.
Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision! - RADACAD
SQL profiler to trace request sessions from power bi.
SQL Server Profiler - SQL Server Profiler | Microsoft Docs
Monitor report performance in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |