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

Issues with Dashboard Auto Refresh

Hi

 

I would appreciate your inputs on following matter

 

I´m using Power BI Desktop and connecting to an On Premis SQL Database. in Direct Query mode.

 

After I´ve created my report in Power BI Desktop I puplish it to the Power BI cloud service.

 

I also configured an On-Premisses Gateway in the Power BI cloud connecting to the SQL database.

 

Now I really would like to know how I get Auto Refresh to work? When the database gets updated the report and dashboard in the Power BI cloud remain the same, the don´t get updated.

 

I´m able to do eight scheduled refreshes a day, of the dashboard but I need more frequent refreshes, such as every fiften minutes.

 

Thanks in advance

 

4 REPLIES 4
Microsoft v-haibl-msft
Microsoft

Re: Issues with Dashboard Auto Refresh

@Samaneh78

 

If you only have a data source which connects to your on premises SQL database, and in Direct Query mode, you can get the dataset refresh every 15 minutes as below.

 

Issues with Dashboard Auto Refresh_1.jpg

 

Best Regards,
Herbert

Samaneh78 Frequent Visitor
Frequent Visitor

Re: Issues with Dashboard Auto Refresh

Hi

 

Thank a lot for taking time to answer my question

 

My view look slightly different than yours

 

Is Cache Refresh the solution I´m missing?

Capture.PNG

 

Best Regards

Samaneh

 

 

 

 

Samaneh78 Frequent Visitor
Frequent Visitor

Re: Issues with Dashboard Auto Refresh

Reading this PBI article, my understanding is that cache refresh is not available in my region yet and that it applies to Direct Query for SQL DB in Azure.

 

https://powerbi.microsoft.com/en-us/blog/announcing-custom-cache-refresh-schedules-in-the-power-bi-s...

 

Is that correct?

 

Best Regards

Samaneh

Microsoft v-haibl-msft
Microsoft

Re: Issues with Dashboard Auto Refresh

@Samaneh78

 

It seems that this feature has not been implemented in all regions yet. When this feature rolls out in your region, Power BI will send you an in-product notification if you are the owner of any such datasets.

 

Best Regards,
Herbert

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)