Forum Discussion

mjkusler's avatar
mjkusler
Frequent Visitor
1 year ago
Solved

Issues with Automated Refreshes on PBI Server - But Works Fine In The App

I have several reports that have up to 30 different data sources. However, several of my reports have the same issue, all with the same data table, which resides in Databricks like all others I conne...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mjkusler,

     

    Even after trying various approaches, If you are still unable to solve the issue you can reach out to Support by raising a ticket with Microsoft Support.

    Please refer below link on how to raise a contact support or support ticket.

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

Hello mjkusler 

 

Power BI’s integration with Databricks requires the Databricks cluster to be active and accessible during scheduled refreshes. If the cluster is offline or terminated, Power BI cannot retrieve data, leading to refresh failures. This dependency is explicitly noted in multiple sources, which recommend ensuring the cluster is online before scheduled refresh times

Instead of relying on an interactive cluster, you can use a Databricks SQL Warehouse, which allows for querying data without requiring a running cluster

Direct query mode could be an option too

 

https://telefonicatech.uk/blog/power-bi-with-azure-databricks-for-dummies-in-15-minutes


https://www.element61.be/en/resource/connecting-power-bi-databricks-lakehouse

 

Please accept the answer if this is useful 

 

 

 

mjkusler's avatar
mjkusler
Frequent Visitor
1 year ago

nilendraFabric I appreicate the response. However, this has all been explored and tested including various different settings, configuartions, code changes, refreshing schedules changes etc. Still no luck.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi mjkusler,

     

    Even after trying various approaches, If you are still unable to solve the issue you can reach out to Support by raising a ticket with Microsoft Support.

    Please refer below link on how to raise a contact support or support ticket.

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Best Regards,
    Hammad.
    Community Support Team

     

    If this post helps then please mark it as a solution, so that other members find it more quickly.

    Thank you.