Showing results for 
Search instead for 
Did you mean: 
New Member

Is there any possibility of refreshing the power bi dashboards for SO Azure without any gateway??



We are trying to refresh the power bi reports from the dashboard directly. Our data source is AZURE Sql Database. When we are refreshing data through either schedule refresh or direct refresh, We are not getting the updated data.


Wanted to know whether there is any feasibility of refreshing dashboards without any gateways?


Any help is appreciated!! Thanks

Community Champion
Community Champion

Just want to add that PowerUpdate allows a single document on a single computer as a free version. That way you can "try before you buy." I have used it in the past but do not currently refresh with that method due to corporate structure. It is a fantastic program, however.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

There are 2 general approaches - refresh in the cloud (as you have described) or refresh locally and publish to the cloud. I personally prefer the latter as there are less moving parts. I use power update ($500) and schedule he refresh on a local machine and publish to the cloud on a schedule without intervention. You can also use OneDrive as the sync mechanism. Of course you still need to make a connection to Azure, but I assume you can do this from a local machine. 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.