incremental refresh issue in PowerBI

[Anonymous]

Hi All, 

I am trying to implement the incremental rfresh in PowerBI and having some issues

The source of my data is SQL server. I have imported few tables from the SQL Server.  I have then created two parameters, RangeStart and RangeEnd. 

I have then applied those parameters to a particular date column in Table X as shown below:

Now, when I right click the table to apply Incremental Refresh, I get the following message.

• Though, I have already defined the parameters.
• Can someone help me what I am doing wrong ? 

Note: I have checked that EnableLoad abd Include in report refresh options are already checked for the table. 

[v-xinruzhu-msft · Accepted solution]

Hi @Anonymous 

The incremental refresh must conform the following rules:

1.Date filtering- the types of parameters(RangeStart and RangeEnd) must be "Date/Time" and the filtered column type should be "Date/Time" or integer data type

2.Query folding - Incremental refresh is designed for data sources that support query folding.

 You can refer to the following links:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#supported-data-sources

Incremental Refresh and Hybrid tables in Power BI: Load Changes Only - RADACAD

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ppm1]

Note that RangeStart and RangeEnd must be DateTime type (not Date). Once that is the case, you likely need to wrap them with Date.From( ) in your Filter step.

Pat

[Anonymous]

Please note that I have just three rows of dummy data