Forum Discussion

FrauLehmann's avatar
FrauLehmann
Frequent Visitor
10 months ago
Solved

Power BI Report Timeout Error - rsQueryTimeoutExceeded (225 sec) on PPU Capacity

Hi everyone, I’m experiencing a timeout issue with one of my reports in Power BI Service and would appreciate any guidance.   My environment • Power BI Service (Cloud) • PPU (Premium Per User) c...
Need Help
  • nandic's avatar
    nandic
    10 months ago

    Hi FrauLehmann ,

    Do you have any comparison regarding amount of data today vs yesterday?

    I suppose only one complex dax metric is the issue.
    Open the report, select the visual which returns timeout issue and one by one delete dax metrics from the visual. Once you delete the one with the issue, data will be show on the visual.
    We can focus on that specific dax metric.

    Provide here dax of that metric, data model screenshot and amount of data and we will see if it can be optimized.

    Cheers,
    Nemanja

nandic's avatar
nandic
Resident Rockstar
10 months ago

Hi FrauLehmann ,

Do you have any comparison regarding amount of data today vs yesterday?

I suppose only one complex dax metric is the issue.
Open the report, select the visual which returns timeout issue and one by one delete dax metrics from the visual. Once you delete the one with the issue, data will be show on the visual.
We can focus on that specific dax metric.

Provide here dax of that metric, data model screenshot and amount of data and we will see if it can be optimized.

Cheers,
Nemanja