Forum Discussion

RuchikaSoni's avatar
RuchikaSoni
Advocate I
6 years ago

Paginated Reports Rendering Extremely Slow

I am trying to explore Paginated Reports in Power BI using the following steps:   1. Created data source using Power BI Dataset connection. 2. Created a simple table on Power BI Report Builder. 3...
Power BI Reports Builder
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I was experiencing severe performance problems until I figured out how to select the correct "level" in the Query Designer. The levels are:

 

Model (gold cube) >> Cubes (with the 3D arrows) > Field Name (SKIP this one) > Members or Field Name (SELECT this one).

 

I tried to drag and drop the first Field Name and performance was awful. I then dropped the dataset and started over using the second Field Name deeper in the node structure. Once I did this performance was awesome.

 

Let me know this helps.

Mike M

Avanade Power BI lead. 

saglamtimur's avatar
saglamtimur
Resolver II
6 years ago

Querying ExecutionLogs (actually they are views under report db) may lead you. For example below screen shot is from [ExecutionLog2]

 TimeDataRetrieval, TimeProcessing and TimeRendering shows at which stage it spends time.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    can i find this metrics for my paginated report using PBI dataset on an oracle database