Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Renu
Frequent Visitor

Power BI Service Data refresh with Azure SQL Database as datasource

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.

4 REPLIES 4
Renu
Frequent Visitor

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors