Forum Discussion
Power BI Service Data refresh with Azure SQL Database as datasource
Some more findings..
My Dataset included Onedrive datasource along with the Azure. Is that stopping the data update? I tested out with Azure only as datasource and i can see it changing every 10mins? Any thoughts/insights?
-Renuka
Renu,
Some more findings..
My Dataset included Onedrive datasource along with the Azure. Is that stopping the data update? I tested out with Azure only as datasource and i can see it changing every 10mins? Any thoughts/insights?
-Renuka
Do you connect to onedrive for business via OAuth web connector? If it is, this may caused by you haven't set the schedule refresh for your onedrive datasource, please check dataset-> schedule refresh in power bi service.
Regards,
Jimmy Tao
@Tao,
Thanks for your reply. I am connecting to Onedrive for business using Personal Gateway. I had scheduled refresh, but i removed it to test and yet wasnt getting the data up to date in Power BI.
If Onedrive is the issue, What are the best ways to pull the Reference Tables/Ancillary tables that are in Excel along with Azure sql database to get the live data?
TIA,
Renuka
Renu,
You can connect to azure sql database with direct query mode.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.