Forum Discussion

swathrddy's avatar
swathrddy
Helper I
1 year ago
Solved

auto Refresh monthly

Hi All,   I created KPI dashboard, Data extracted from Excel file (See pic). I am manually refreshing the data everymonth and then Unpivoting the NEW Date/Month Column.     = Table.Unpivot(#"Chan...
Need Help
  • lkalawski's avatar
    lkalawski
    1 year ago

    Hi swathrddy,

     

    Change the logic to UnpivotOtherColumns and then you don't need to edit the code every month.

    1. Start point

    2. Unpivot Other columns (select columns which you don't want to unpivot and then click on this option):

    3. The result:

     

    Now you can setup a schedule refresh in Power Bi service.

     

     

    Memorable Member | Former Super User
    If I helped, please accept the solution and give kudos! 
    Linkedin

     

Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Hello swathrddy ,

 

you can schedule a refresh on Power bi service and the transformations you did in power query will automatically be applied.