Refresh Excel vi Analyze in Excel / Power BI Publisher

[JorisVoorn]

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 

[v-xuding-msft]

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 fo... 

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]

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

[VuongLM93]

@JorisVoorn 

Did u find any way to do ?