topic Re: Power BI Service Data refresh with Azure SQL Database as datasource in Service

Power BI Service Data refresh with Azure SQL Database as datasource

Renu — Mon, 07 Jan 2019 20:10:31 GMT

Hi,

I am in a confused state right now while trying to understand the refresh of power bi report with Azure sql database as datasource. I am using Direct Query mode to connect to the Azure. The Data on Azure is now getting refreshed every 10mins, with the hope that the data on Power BI will get updated too. But that is not the case. we have to wait an hour to see the data updated ,unless I manually refreshed the dataset. I have been reading the Questions and answers in this power BI Community, and noticed that lot of people are saying that visual interaction in my scenario will cause the data to get updated. I already spent half a day in understanding/trouble shooting, but couldnt figure out. Any help is appreciated.

Is waiting an hour is the limitation of power bi pro? or any setting that i am missing?

Thanks,

Renuka.

Re: Power BI Service Data refresh with Azure SQL Database as datasource

Renu — Mon, 07 Jan 2019 21:29:24 GMT

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

Re: Power BI Service Data refresh with Azure SQL Database as datasource

v-yuta-msft — Tue, 08 Jan 2019 08:11:37 GMT

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

Re: Power BI Service Data refresh with Azure SQL Database as datasource

Renu — Tue, 08 Jan 2019 21:30:47 GMT

@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

Re: Power BI Service Data refresh with Azure SQL Database as datasource

v-yuta-msft — Wed, 30 Jan 2019 05:33:03 GMT

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.