Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic data load in Power BI using Advance editor

Hello Experts,

 

I am using SAP BW as source to load the data in Power BI. I have created vairables in SAP BW Bex query level and given inputs to load the data. Everything was working fine with static inputs.  Now I am looking for the dynamic data load for last 90 days always.

Is there any way to load the data dynamically using advance editor. Kindly put some suggestions to resolve the issue.

 

Regards,

Ajay

Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,

    Before source create these two dates and use that where you are giving the dates

     

    end_date = Date.From(DateTime.FixedLocalNow()),

    start_date = Date.Adddays(Date.From(DateTime.FixedLocalNow()),-90) ,

    Source = <Your code >