October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
Hi all.
We're creating some dashboards on Power BI desktop,using direct query (we're connecting our reports/dashboards into a sql server 2014 enterprise edition machine) and we would like to display the dashboard on a tv/monitor.
But we're facing some issues with the dashboard refresh.
Even using the direct query, the dashboard content are not being updated.
However, if i press F5 or hit the refresh buttom , the dashboard charts gets updated.
is this the expected behavior?
We would like some kind of automated refresh (without manual intervention).
Also if we refresh the browser, the dashboard page gets out of the fullscreem mode.
Thanks,
Solved! Go to Solution.
Hi @lcampos,
If there is loading icon(power bi icon), i think there are some problems with your datasets or gateway. Are you using Direct Query for on-premise sources?
This chrome extension did trick for us.
https://spgaurav.blogspot.com/2019/04/chrome-plugin-to-auto-refresh-power-bi.html
Note : This wont work with full sceen
Hi @lcampos,
Even though you are using Direct Query for reports & Dashboard, Tiles in Dashboard maybe take some lagging/delay about one hour. You could manually observe the refreshing by click to Open Menu of top right corner of tile and choose Tile Detils -> Technical Detais (or you could choose show Display last refresh time)
Thanks for the repply.
Indeed, i can see the details about the last refresh using this menu.
Its seems that , the dashboard tile is trying to refresh, but the refresh is failing (the tile is gone and there's the power bi icon on the midle of a blank screen).
Have you seem this before?
Thanks
Hi @lcampos,
If there is loading icon(power bi icon), i think there are some problems with your datasets or gateway. Are you using Direct Query for on-premise sources?
Thanks again for the response, and sorry for the delay on my feedback.
We're using Direct Query for on-premise!
I'm not sure if we were facing some network( or any other issue) with our gateway on last week, but now , its seems that our dashboard tiles are up to date and as far as i could see, they're being refreshed every 15/16 minutes.
Again, thanks for your time to help me.
Regards,
Luiz