Forum Discussion

mjoseph111's avatar
mjoseph111
Helper II
11 months ago
Solved

Report Refresh Failures

We are encountering a rising number of issues related to dataset refreshes in our Power BI environment from last 2 days, Our organization operates under a Microsoft P1 license, without access to Fabr...
Need Help
  • mjoseph111's avatar
    mjoseph111
    11 months ago

    Thanks @vivien57  @Shahid12523  Anonymous and @danextian  for the valuable inputs here.
    I've identified the root cause of the failure; it was due to a service interruption that occurred on September 3rd. That disruption directly led to the issue we experienced.
    If there's a service interruption or issue with the Power BI cloud service, you can monitor its status by visiting the support page Microsoft Fabric service status .  This support page provides real-time updates and helps identify any ongoing disruptions.

    Thank you all for your support and patience while I investigated. Much appreciated!

danextian's avatar
danextian
Super User
11 months ago

Hi mjoseph111 

Many possible reasons:

  • Complex queries
  • You're making Power Query all or almost all transformations instead of doing it upstream
  • High cardinality columns such as datetime. Split them into date and time columns. If you don't need the seconds, remove the as well.
  • Merge - fine with small data but can contribute to slow refresh with large data
  • Wide tables - do you need all the columns?
  • Expensive DAX queries - you have a dedicated capacity which is shared across data refreshes and rendering of visuals

Or maybe you'll need a higher capacity because it is currently being stretched to its limits with the number of users and reports.