Hello everybody,
I'm about to implement a new Stored Procedure into PowerBI, but theres an additional requirement andI dont know yet how to approach that requirement.
It is possible to give 2 parameters for the stored procedure: Year and Month. If I leave the parameters empty, then it will return me the results for the current month only. What I need is to show the results of the entire last year (including current month). The stored procedure(query) is quiete heavy on the performance part, so what I would like to know if I can gather the data from previous months once, and refresh the data from the current month on daily basis.
What I was thinking was to create a duplicate query in PowerBI and connect to the SP twice. In one query I set the previous 11 months manually and then disable the report refresh functionality. And the other query I would leave the parameters empty. Then I would merge the two SP's into one. Problem is that I can't make the parameter dynamic like: Previous Months(11). I will need to fill in the numbers of the months.
Any thoughts?
