Unable to use Incremental Refresh

[Anonymous]

 Hi

I'm trying to use Incremental Refresh, but the option doesn't appear when I right click on table. This is what I've done so far:

a) Imported a table from SQL Server with Query Folding

b) Create two date/time parameters, named RangeStart and RangeEnd

c) Filtered a datetime column with "between" RangeStart and RangeEnd

I'm using PowerBI Desktop version: 2.79.5768.1082 64-bit (march 2020) and I do have Premium License.

Thanks!

[amitchandak]

@Anonymous , refer if this can help

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[parry2k · Accepted solution]

@Anonymous you are not suppose to go back to power query, after close the query window, you see all the tables in the model and that's where you will see this option. 

You are making it super complicated 😁

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[parry2k]

@Anonymous once you apply the queries steps, close and apply and then on the model, in the right side pane, on right-click you will incremental refresh option. It is not in power query but after you apply the queries

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Thanks

I've just used "Closed&Apply", but when I come back into PowerQuery, I still can't find the option 😅

[Anonymous]

Finally I've found the option. It has been changed of position.

Thanks!!