Refresh of Power BI dashboard on the top MS Azure Cloud

[alextarki]

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 

[v-shex-msft]

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

[nickyvv]

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.

[alextarki]

How can I turn a report to dashboard?

[nickyvv]

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.

[alextarki]

[alextarki]

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)

[alextarki]

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