Forum Discussion

sirahcy's avatar
sirahcy
Frequent Visitor
2 years ago

PBI Refresh Halted on Workspace

Hi MS Support & Community,

My firm has issue with PBI refresh on PBI workspace not being processed and queries were not submitted to the cluster.  Please advise what can be the cause here and what can we use to investigate further?

  • Our overnight batch kicked off PBI Refresh via API @ 9:39pm 9/25/2023 which ran over for 20+ minutes and was still not completed.  While the refresh status shows the PBI refresh is in progress, we don’t see any activity or queries running on the DataBricks SQL serverless cluster.  The cluster was able to process other PBI refreshes during that time.
  • We made couple attempts to fix the issue but observed the same outcome, not seeing any refresh activity on the cluster.
    • Canceled the refresh, restarted the serverless cluster, manually trigger the refresh. 
    • Canceled the refresh, pointed to another standard cluster, manually trigger the refresh.
  • At the end, we just canceled the outstanding refresh.  About 2+ hours later, the subsequent scheduled PBI refresh on the same dataset was able to succeed.  

PBI Refresh history:

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi sirahcy ,

     

    If the data volume is too large, it might cause the refresh to time out. You could try reducing the amount of data being imported.
    Make sure the gateway version is up-to-date and that the report has a gateway selected. If there is no gateway selected, the data source might have changed or might be missing.
    An outdated Power BI Desktop version could cause issues. Try updating to the latest version. Sometimes, clearing your internet browser cache can help resolve issues. Check if Power BI Desktop can connect to the database.
    For certain queries, you can make sure they aren’t loaded in Power BI Desktop. Unselect ‘Enable load’ in the context menu of the query in Power Query Editor.

     

    Best regards.
    Community Support Team_Caitlyn

    • sirahcy's avatar
      sirahcy
      Frequent Visitor
      2 years ago

      Thanks. 

      • We had the issue on the PBI workspace which does not have gateway setup. 
      • About the PBI desktop version, because this is a Large dataset, we've been using ALM toolkit to publish changes to the dataset on workspace.  In this case, do we still need to update the desktop version already published online while ago? 
      • Yes.  PBI desktop was able to connect to the database, though the dataset online was not refreshing.
      • What kind of queries should not be loded?  We enabled load for all data sources.