Hi there
Can someone please help me with the below.
I have a Stored Proc. Within there are multiple queries which are controlled by the below 3 parameters.
@DatasetFlag VARCHAR
@Year INT
@month INT
In the FROM Clause from each query within the SP it will say
FROM dataset_name (@DatasetFlag, @year, @month)
Each query is built like this but has different measure and column names containes
IF @DatasetFlag = 'Stoke-on-Trent'
BEGIN
FROM FROM dataset_name (@DatasetFlag, @year, @month) - year and month will need to be parameters too
WHERE
GROUP BY
ORDER BY
END;
IF @DatasetFlag = 'Manchester'
BEGIN
FROM FROM dataset_name (@DatasetFlag, @year, @month)
WHERE
GROUP BY
ORDER BY
END;
And so on for each different set of datasets - I have about 30 in the same SP and each is different
Is it possible to bring this in to Power BI, calling each parameter (dataset flag which controls the local authority I wan to see the results for, the year parameters for the measures relating to that year, and the month parameters for the measures relating to that month and then for it to only show the columns relating to that particular query.
Does this make sense? Hope so.
Thanks for reading
Kind regards
Karen
