This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Hi,
I have a SQL DB that is serverless and not in use except for two times in day (for approx 15 min each). But oddly, I am noticing that the DB stays online (though autopause set to 1 hour) lot more often. I noticed that there are background queries being executed quite often under my username from power BI. We used this DB against multiple power bi report a while ago, and no power bi reports are set to refresh using this DB.
While looking at the extended events (as auditing was enabled), I see that almost all of the events are like the below (with the ip of msft's datacenter) with using power bi.
The kind of sql staments in the extended events are like these.
Any recommendations on how to troubleshoot this further and figure out what is using my credentials to generate these queries, resulting in the serverless DB to wake up often and stay online (incurring charges).
Thank you.
It seems like schema discovery queries coming from Power BI Service/Gateway, even when dataset refresh is off, the service and/or on-premises data gateway may periodically validate connections and read schema (do some background health checks). Try to remove the data source for that database on the gateway or delete connections to that database on any dataset that use the database..
Thank you @Alberto Morillo for your response. We do not have any on-premise db for the data gateway. Yes, there are reports that use the data source credential to that azure sql db, but rarely are those reports accessed daily (maybe twice a week). If i delete that data source connection from power bi service, then users wont be able to refresh or view the report whenever they do though. Correct ?
Yes, any report or dataset that relies on that connection will fail to refresh and will also fail to load live/direct query visuals. If you leave the connection as is right now, datasets in Power BI service can still trigger metadata checks automatically, and data source credential validation happens periodically also in the service, even without a scheduled refresh.
One option you have is to publish a static PBIX with imported data. Refresh it manually in Power BI Desktop when needed, then re-upload. The Azure SQL DB will only be hit when you decide.