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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
alextarki
Helper I
Helper I

Refresh of Power BI dashboard on the top MS Azure Cloud

HI, 

I have created Power BI report on the top of DirectQuery to MS Azure Cloud tables and published it over Power Pro

I have discovered that data of the report wasn't updated following the update on the source side. I have executed the refresh button directly in the Power Pro report (see the square colored red on below screenshot) and have got report successfully updated. 

 

Is there any way to automate data refresh on the top of DirectQuery? 

 

Thanks and sunny day 

 

pic111.jpg

 

 

 

 

7 REPLIES 7
v-shex-msft
Community Support
Community Support

Hi @alextarki,

Have you mixed other type of data source in your report?

Use composite models in Power BI Desktop 
Have you enabled sso option on your data source that uses the end user credentials to access the corresponding records?

Configure Kerberos-based SSO from Power BI service to on-premises data sources 

Please share more detailed information to help us clarify your scenario.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
nickyvv
Community Champion
Community Champion

Hi @alextarki

 

there are a few conflicting statements in your question: DirectQuery and a scheduled refresh don't go together.

And you have a report visual in your screenshot, not a dashboard tile. 🙂

 

But regarding your question, the dataset has to be refreshed, either on demand (Refresh now) or scheduled, and then the reports are refreshed/updated automatically. But, it might be that you have to refresh the page (F5, or the refresh option you use), because the browser cached certain parts of the report.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


How can I turn a report to dashboard?

If you have a Direct Query source you shouldn't have to refresh. Can you show the settings of your dataset in the Power BI Service with a screenshot? If it says Scheduled Refresh it's Import, Scheduled Cache Refresh means DirectQuery.

 

Please have a look over here how to Pin tiles to a dashboard.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


pic112.jpg

Thanks

Report on the top of DirectQuery doesn't refresh anything unless you press on refresh visuals on the top right corner (see screenshot on my initial post)

Thanks

 

I open a report that is sitting on the top of DirectQuery of MS Azure clouud database and I have to press Refresh button every time.

Is there any change to automate it?

 

Thanks 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.