Hi Team,
I am using the SAP BW for connecting the data. I have 6 years of data . Initially i am pulling only 2 years of data into Power Bi desktop, so that i wont get any memory issues when i try to load all the 6 years of data.
And Fiscal Year is a variable in SAP Bex and below is the power quey code for the same with 2 years filtered.
{Cube.ApplyParameter, "[0S_FYEAR]", {{"[0FISCYEAR].[K22017]", "[0FISCYEAR].[K22018]"}}},
Now i want to create a parameter in Power BI and use that same in my Power Query.
So that i can publish the pbix file with 2 years of data in online and change the parameter value for all the six years , so that it will refresh in online without any issues.
Please let me know how to achieve this solution.
Thanks in advance.
