Microsoft ssas tabular performance with regards to power bi

[Anonymous]

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 /

[Anonymous · Accepted 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