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

SQL Azure Database with DirectQuery not automatically refreshing the report

Hello,

 

I've created a file with Power BI Desktop using a DirectQuery to an Azure SQL Database. I uploaded this pbix to Power BI Services then reconfigured the credentials for the database and the reports. When navigating to the report or interactingwith it, I indeed have live queriesand receive the last data but if I let the report and don't interact with it, there is no automatic refresh of this report. To have a refresh of the report I need to pres the refresh button or navigate to another page and come back. More, if I create a tile, it's never refreshed.

 

Is it the expected behaviour or I'm missing something? Thx

1 ACCEPTED SOLUTION
konstantinos
Memorable Member
Memorable Member

This is the expected behaviour. The direct connections sends live queries and retrieve data when you interact with visuals. The reports don't refresh automatically with new data. For this you need to push data into powerbi with APIs. 

The tiles refresh in a ten minute interval moreless. Sometimes you need to refresh the browser , keeps the cashed data

Konstantinos Ioannou

View solution in original post

4 REPLIES 4
konstantinos
Memorable Member
Memorable Member

This is the expected behaviour. The direct connections sends live queries and retrieve data when you interact with visuals. The reports don't refresh automatically with new data. For this you need to push data into powerbi with APIs. 

The tiles refresh in a ten minute interval moreless. Sometimes you need to refresh the browser , keeps the cashed data

Konstantinos Ioannou

Having to refresh the browser is an issue. I'd like to display direct connect data on TVs around the office. I can't effectively do this unless the dashboards refresh on their own. If I set up the browser to auto-refresh (ex. Google Chrome Revolver extension), I can't use the full screen mode, which is a shame.

 

Any thoughts on better ways to query/display live data?

Bjoern
Continued Contributor
Continued Contributor

Correct me, if I am wrong, but I have seen videos where streaming data is displayed in a dashboard tile and gets automatically updated. I think it was the demo about the toll bridge in New York (?). Man Surprised

I believe you're correct. Good point

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