Forum Discussion

Erik1980's avatar
Erik1980
Regular Visitor
2 years ago

Parameters incremental refresh not found

Hi,   I configured incremental refresh on my datamodel. I believe I did everything okay in PowerBI Desktop and was able to publish the model to PowerBI Service ans set refresh rate in settings. How...
Need Help
aj1973's avatar
aj1973
Community Champion
2 years ago

Hi Erik1980 

First step is to create parameters " RangeStart and RangeEnd" in Power Query, did you?

  • Erik1980's avatar
    Erik1980
    Regular Visitor
    2 years ago

    Yep. Did that. Enabled load. Used them to customize the filter in the appropriate colomn (date type set to date/time) and configured the fct_table

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Is your Fact table in a Direct Query mode?

      • Erik1980's avatar
        Erik1980
        Regular Visitor
        2 years ago

        No. It's input mode

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Did you check the native query of the Filtered row in Power Query? if it is greyed out the it won't work in the service and you need to check the steps before which one is causing it

      • Erik1980's avatar
        Erik1980
        Regular Visitor
        2 years ago

        Hi, thanks for your reply. The native querie is fine. That is not the issue. 

    • sergej_og's avatar
      sergej_og
      Super User
      2 years ago

      Hey Erik,
      your paramenters are also defined as Date/Time?

       

      • Erik1980's avatar
        Erik1980
        Regular Visitor
        2 years ago

        Yes, I did