Incremental Refresh Issue

[Anonymous]

Hi,
Sorry to post about same topic I discussed earlier. I have issue with incremental refresh. I will mention the steps done earlier.

Please consider I have trial power bi pro account (23 days left).

1. I added parameters like this,

I retreive data from mysql (cloud) database AWS from Views and filter from 2020-01-01 . Its updating everyday (RangeEnd will be change on future). 

2. I added filter to the created_at field like this,

3. My visual looks like this, 

4. published in to our tenent on one drive. 

5. The dashboard which added incremental refresh is new power bi dashboard. 

6. 

7.  My workspace -> Datasets

If I added,
Scheduled Refresh -> Time   that means refresh dataset on these time peiods , and I can add total 8 time periods on pro liscence Right ?

8. My workspace view

Those are the steps I have taken so far. 

Earlier(first time I added incremental refresh) I got error like this.

But I did few changes for current state. Now I have no errors or emails. 
Am I doing wrong or correct. Please correct me if im wrong. Feel free to ask if my steps not clear.

Thank You.

[Anonymous · Accepted solution]

Thank you for the answers.
I changed personal gateway to standered gateway , And also did some testing and seems like its working fine.
I dont know why it didnt work on personal mode.
Thank you

[Anonymous]

@Anonymous 
1. Yes, scheduled refresh refreshes and updates the dataset, and then dashboard tile automatic refreshes based on the updated datset. But report does not auto-refresh to show the newest data.

2. It is not converting, you pin visuals from report to dashboard. There is a quick way, if you want to make everything automatically refresh once schedule refresh is done, you can pin the entire report page to dashboard, the newest data will display on the dashboard. How to pin an entire report page to a Power BI dashboard - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,
Testing means the dashboard pinned from report new powerbi dashboard.
I dont see the refresh time on testing dashboard

do i need to change anything ?
Thank You

[Anonymous]

Hi, sorry to disturb.
After the first time pin report to dashboard its updated correctly. On second and third time it didnt updated automatically, 
I also refreshed manually .

But seems like its not refreshing.

What Im doing wrong?
Thank You

[Anonymous]

@Anonymous 
I see no problem with your incremental refresh setup. I never used personal gateway to configure incremental refresh and I found no limitation on it, but seems works with your case.

Incremental refresh in Power BI - Power BI | Microsoft Docs

Regarding to Refresh, there is a difference between Dashboard and Report refresh. The Dashboard Tiles refresh with dataset, which means the tiles automatically refresh once the dataset is refresh. But PBI Report will not refresh automatically when dataset is refreshed, you need to manual refresh the report.

Data refresh in Power BI - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, Thank you for the response.

I have another question. 
1. If I do the Scheduled refresh, does it affect dataset (update) ?
2. Do I need to convert Report  --> Dashboard to expect visualization refresh ?

Thank You

[amitchandak]

@Anonymous , Try it after sometime. If did not work, then please log an issue - https://community.powerbi.com/t5/Issues/idb-p/Issues

[Anonymous]

hi,

I have question with scheduled dashboard refresh,

1. I added scheduled refresh like this 

2. When its come to 11.30 AM I refreshed it from browser . then graph is changed .

and after i added few data to the DB and checked with another scheduled time. but it didnt updated.

3.  PB desktop view after refresh(local pbix file) - expected result

 

4. Below is the published PB report that changes not applied yet

5. 

6. I didnt get any emails about data refresh issue.  

7. Is their any place to find the dataset refreshed or not ?

8. If I refresh browser , is that best approch to check data changes?

I have trial power bi pro account and 22 days left to expire. 

9. I couldnt figure out what Im doing wrong?

10. Can this be a issue. 

Thank You