Forum Discussion
Azure SQL Data Refresh
Hopefully not..you will have to wait..(again no tried )
https://support.powerbi.com/knowledgebase/articles/581421-azure-sql-database-with-direct-connect
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.
Cool, I'll be interested to know if it works with the gateway.
