Unable to configure Incremental Refresh for Power BI Pro

[rohitk]

Hi Guys,

I am try to configure Incremental Refresh for my one of the Power BI report. I am facing following issues:

1. As per Microsoft documentation, I configured Incremental Refresh along with setting up the parameters. Then to complete the final step , I login to Power BI seriver and click on Dataset -> Schedule Refresh.

2. In Schedule refresh option - > I am unable to see Schedule Refresh (This happens to dataset over which parameters are applied)

3. Therefore Power BI Service is treaing the dataset as Direct query and not the Import mode.

4. Attached are few of the screenshots, any help over this topic will be great.

Thank you

Power BI Service

Import mode in desktop

Parameters added

[Oliveti]

Hi rohitk,

I have had same issue as you, but I managed to solve the issue by upgrading the PBI Desktop to the latest version (august 2020).

The July version we both experienced this issue on seem to cause the connection of the dataset to change to Direct Query as soon as I set the custom filter on with RangeStart/End.

Using the August version of PBI dekstop this is no longer the issue.

Give it a try.

[GilbertQ]

Hi there

Just to confirm you did configure the Incremental refresh policy on your table before uploading to the PBI Service?

And you are using the latest version of Power BI Desktop?

[rohitk]

Hi @GilbertQ

1. Yes, I configured before uploading it to PBI Service,

2. Yes, I am using latest version : 2.83.5894.721 64-bit (July 2020)

Thanks you 

[GilbertQ]

I am not sure why it is not working

What about if you delete the dataset from the PBI Service.

Then re-upload the PBIX.

And finally is the size of the PBIX big enough to have imported the data?