Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Stored Procedures and Incremental Refresh

Hello,

I need help! I've started a new job, and almost all of the existing Power BI reports have been created using stored procedures.

I'm not a SQL person!

I'm wanting to implement Incremental refresh - I know there's a way to inject the SQL statement to force parameters for IR when using SELECT statements, but is there another workaround when stored procedures are being used? As far as I can tell, the only parameters allowed are the ones spedifically defined in the sproc. Is there another way to make IR work?

Any way to add parameters that will actually fold back to the source?

Here's hoping!!

 

Thanks,

Kim 

Need Help

2 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Anonymous ;
    You could try to parameter to filter.

    With Dynamic M Query Parameters, model authors can let report viewers use filters or slicers to set the value(s) for an M Query Parameter, which can be especially useful for query performance optimizations. With Dynamic M Query Parameters, model authors have more control over how filter selections get incorporated into DirectQuery source queries.

    Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      This doesn't really answer my problem of needing to incrementally refresh. Thank you though.