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
My test:
The tiles are not refreshing.( 3 hours ) .Although when you click a tile the report queries the DB and the graphs are refreshing..Strange but the report keeps cached the old data..so when I go back to dashboard & to report it queries again..doesn't keep the latest query values
Me again....
I can now confirm that the Azure SQL data refreshes when I close Power BI and log back in. I suspect it also refreshes after a while (I've not sat waiting to see). The mobile app also refreshes when closed and re-opened..
To get this to work I had to create the "Get Data" connection on the powerbi website...
However, I now have another issue. A new table has been added to the Azure SQL database, it has data and I can query it from MS Management Studio..However, the new table is not showing up on the Power BI Dataset..The data in the existing dataset has refreshed but the new table is not visible.
Any ideas? I hope I don't have to delete the dataset and start again..
Hopefully not..you will have to wait..(again no tried )
https://support.powerbi.com/knowledgebase/articles/581421-azure-sql-database-with-direct-connect
Hi,
Is there a way to manually trigger schema update? Or will I need to create a new connection, and redo all the reports?
Hi Sparso
At the moment I am assuming that I have to reconnect the dataset for the schemer to refresh. It allows you to connect the same database twice but I suspect that will become messy. So until Microsoft add an auto-refresh or manual (either way is good), I'm rebuilding my reports each time.
:(
By the way, can you vote for this feature here please
