PowerBI Service refresh issues after Azure SQL VM reboot
We have an Azure SQL VM that hosts our data as well as our on‑premises Power BI gateway. I reboot this VM regularly (about once a month), and historically this has never caused any problems.
However, after a reboot a few days ago, all of our Power BI Service refreshes have become extremely slow or fail entirely. During a refresh, the VM’s CPU spikes to nearly 100%, making the server unusable.
I’ve already tried:
• Multiple additional reboots
• Excluding relevant folders/files from Microsoft Defender scans
• Updating the gateway to the latest version
Unfortunately, none of these steps have improved refresh times or CPU utilization.
Has anyone experienced something similar or have ideas on what might have changed after the reboot? I’m trying to understand what could have caused this sudden performance issue when previous reboots never caused any trouble and restore the performance to how it was before this latest reboot.