Forum Discussion

swathrddy's avatar
swathrddy
Icon for Helper I rankHelper I
2 years 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
    2 years 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
Icon for Super User rankSuper User
2 years ago

Hello swathrddy ,

 

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