cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smdaly218 Frequent Visitor
Frequent Visitor

Direct query refresh dashboard automatically instead of manually refreshing

I have connected to an Oracle DB using Direct Query which solved my refresh issue. However I am using this dashboard to show real time data updates for the Service Desk. If I manually refresh the data, I will see the updates on the dashboard. What I am looking for is the data to be automatically refreshed on the screen just like it is in the background. Simply put, can I continuously update the visualizations without clicking to refresh the dashboard?

 

Extract from Power BI helps to explain my predicament.

 

When you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated. Because there is a direct connection between Power BI and the database, there is no need to schedule refresh.

 

Success would be direct query that updates visualizations every 15 minutes per refresh schedule. I appreciate any help on this one!

1 ACCEPTED SOLUTION

Accepted Solutions
smdaly218 Frequent Visitor
Frequent Visitor

Re: Direct query refresh dashboard automatically instead of manually refreshing

I did not delve into streaming as yet due to the extensions you mentioned worked for me. I was able to add a Refresh extension in Chrome and have it refresh every 5 minutes. This is a good interval for me and using F11, provides a "decent" experience. I will continue to evolve my skills with streaming when time allows. 

 

Thanks for the solution!

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: Direct query refresh dashboard automatically instead of manually refreshing


@smdaly218 wrote:

I have connected to an Oracle DB using Direct Query which solved my refresh issue. However I am using this dashboard to show real time data updates for the Service Desk. If I manually refresh the data, I will see the updates on the dashboard. What I am looking for is the data to be automatically refreshed on the screen just like it is in the background. Simply put, can I continuously update the visualizations without clicking to refresh the dashboard?

 

Extract from Power BI helps to explain my predicament.

 

When you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated. Because there is a direct connection between Power BI and the database, there is no need to schedule refresh.

 

Success would be direct query that updates visualizations every 15 minutes per refresh schedule. I appreciate any help on this one!


@smdaly218

The answer is no. Without any interaction, the internal cache will be refreshed every 15 minutes by default. The real 'realtime' feature in Power BI is Real-time streaming.

 

By the way, maybe you can install some brower extentions to do the auto "F5".

smdaly218 Frequent Visitor
Frequent Visitor

Re: Direct query refresh dashboard automatically instead of manually refreshing

I did not delve into streaming as yet due to the extensions you mentioned worked for me. I was able to add a Refresh extension in Chrome and have it refresh every 5 minutes. This is a good interval for me and using F11, provides a "decent" experience. I will continue to evolve my skills with streaming when time allows. 

 

Thanks for the solution!

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 123 members 1,855 guests
Please welcome our newest community members: