Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to use Incremental Refresh

 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!

 

 

 

 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    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.⚡

     

     

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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

        Thanks!!

         

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      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.⚡