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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a power query that is connected to a couple of sql tables. The data in the sql tables is constantly being updated. Is it possible to update the power query file without going into it to refresh it? Reason I'm asking, is that the power query is feeding Power BI reports that the end user wouldn't know how to update. I would like for the power query file to be updated automatically if possible.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Yes it can be done. I don't know if any of these techniques with work with a connection to a SQL server ...
Here are a few options https://exceloffthegrid.com/auto-refresh-power-query/