Load SAP BW Data by passing Dynamic date range

[Anonymous]

Hi Guyz,

I am new to PowerBI, there is situation where i am getting dataload issue due to one of variable create in Powerbi is not found with SAP BW. For which i have to set a For loop or any loop condition so that it can bypass the variable which are not found.

Data loading is done on Basis of date field and is in the format 202004(i.e. 2020 April) . i need to load the data from Previous fiscal year i.e from 202004 to current date. Both from and to date should be dynamic. the SAP BW field is ZCMTH_PSD which has dates in format as mentioned(i.e. 202004).

PLease help how should i do it using mquery . Help required urgently

[v-kelly-msft]

Hi  @Anonymous ,

I guess you should use query parameter,check the reference below:

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!