Forum Discussion

JorisVoorn's avatar
JorisVoorn
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Refresh Excel vi Analyze in Excel / Power BI Publisher

Dear all,

 

Imagine that I have Power BI Data set. I need to create Excel template where will be data from Power BI Data set available, therefore I have used Analyze in Excel (later Power BI Publisher) to connect Power BI dataset to Excel and create custom template in Excel.

 

This excel in stored on Sharepoint.

 

The issue is that ammount of data are relaitively big and I want to create this template all the time up to date without necessity that user need to hit refresh all buttton in Excel and wait for a long time.

 

The idea is to create some kind of automatic refresh of this excel template in not working hours so, refresh will be proceeded and PBI users will be ready to use the templates wihout necessity to click and wait.

 

Any ideas?

 

some kind of Flow on sharepoint?

 

Thank you in advance

 

BR

 

Pavel 

Tips and Tricks

3 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi JorisVoorn ,

    For Analyze in Excel and Power BI publisher for Excel, they are both live connection with Power BI Dataset. That means, whenever we open the Excel file, the data is up-to-date. If just want to refresh while opening, we need to click Refresh button.  For more details, please reference the blogs.

    Connect and analyze Power BI data directly from Excel, with the July update of Power BI publisher for Excel 

    Power BI and Excel; More than just an Integration 

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

    • JorisVoorn's avatar
      JorisVoorn
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Hi,

       

      Thank you for answer, but the point is I would like to avoid necessity to open a file and wait until Excel refresh data from Analyze in Excel connection. 

       

      I want to create scheduled refresh of excel that will run the refresh while stored on Sharepoint and when user opens the file, it will be already refreshed.

       

      Best regards

       

      Pavel