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.
Did nothing...
If you connect to Azure SQL from PBI Desktop the connection is not live ( the data are stored in PBI desktop data model) ..You need to schedule refresh..No need for Personal DMG..In order for the Azure SQL to be "live" ( refresh every 15 min & with quering ) needs to be connected through the "Get Data" Databases options..
Up to now there is no "live connection" to Azure SQL as for SSAS in PBI Desktop..
**edited .. for live Azure SQL you need Pro lisence
Thanks for the reply...
I now realise that if the dataset is in Power BI desktop then it needs to be Published to take affect. But if I create the Data Link in the cloud through "Get Data", I assume this is different....But it is not...The data cannot be refreshed nor is it refreshed automatically. So with Azure it seems right now either way nothing can be done but delete and start again? Surly this cannot be right?
When trying to refresh the Azure linked DB this appears...
"You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model."
Basically my steps are:
- Get Data directly from Azure SQL Database - (It gets the latest)
- Data changes but Power BI does not update
- Start Again