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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I'd love to try this but I'm having a hard time following. Can you post a screenshot or two exampling what you did please? Thank you

  • 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