Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Refresh Excel Workbook published automatically on demand

Hello experts,   We have a CSV file present on sharepoint. We have an excel file uploaded on Power BI Service which is connected to that CSV through get data approach. We want an automated approac...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hello otravers ,

 

Thank you for the suggestion.

If we go with analyse in excel it will create a pivot table. We don't want a pivot table.

We want to get our workbook refreshed automatically on demand.

  • otravers's avatar
    otravers
    Community Champion
    3 years ago

    You'll have to test whether a Power Query refresh can be automated via Excel OfficeScripts, last time I checked that wasn't yet the case. If it doesn't work, you want to try Power Automate Desktop.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello otravers ,

       

      Thank you so much for your suggestion.

      I tried Power Query Refresh through Office scripts but it is not working yet and Power Automate Desktop flow is not in our context.


      Do we have any other way to achieve it ?

      • otravers's avatar
        otravers
        Community Champion
        3 years ago

        I'd try generating an Excel table using Power Automate but that might imply deleting/recreating the workbook rather than "refreshing" it.