Forum Discussion
Azure SQL Data Refresh
Hi There
We have a Azure SQL database that is kept refreshed by Azyre Sync Services. Then we have Power BI datasource linked to this Azure SQL database.
There should be no need to refresh the Power BI reports but when I look at them they are never refreshed. When I click on Refresh it says I need a Gateway installed, but that does not sound right?
When you seutp an Azure SQL database it says there is no refresh required. This surely means the data should always be as what is in the Database?
Am I missing something? Does one Gateway need to be running anyway?
Hopefully not..you will have to wait..(again no tried )
https://support.powerbi.com/knowledgebase/articles/581421-azure-sql-database-with-direct-connect
15 Replies
Well, it says that Azure SQL Database doesn't require a gateway and supports refresh:
https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi
But it also has three asterisks that point you to this article:
Yup, I found that too and it's a strange one..
When you login to Power BI Desktop the data is not fresh. You have to Refresh to load the data and then it all updates (graphs etc)..
But at that point the web is still out of date. I have to then Publish the reports before the web updates. I must be missing something? I'm now installing the Power BI gateway just ot see if it makes any difference. I'm not setting any refresh there as it won't allow it on an Azure SQL db..
Further to this...I've not installed the Power BI gateway and the Azure SQL server is now visible under my Manage Datasources section..It required me to edit the credentials and seems to be up now.
My data refreshes at 12:00 and I'll see if the data is now live...It does seem you need at least one gateway running.
