cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
J_K_
Level: Powered On

Re: Looking to Refresh an Excel workbook in a SharePoint Online DocLib

Thanks for the suggestion. But it does not workin my case, unfortunately. Do you have an example where this is actually working?

mnmsymmons
Level: Powered On

Re: Looking to Refresh an Excel workbook in a SharePoint Online DocLib

Hi @J_K_ 

 

I followed the steps recommended to try and update two seperate excel files with differents types of data connections, results as follows:

  1. First file is a PowerPivot linked to PowerBI data - like your situation, the file was modified, saved and the flow was successful but when I go in straight afterwards I can see the data has not actually refreshed. FAIL
  2. Second file is a PowerQuery data connection to the first excel file (i've used this to essentially complete formatting and calculations on the first data set so that it is in a table format that can be read and used by Flow to add the data to a SharePoint list which is then used by a PowerApp) - This works, If I first manually refresh file 1 and then run this flow the second file has saved with the updated data. PASS

So it looks like the Flow Update File option will not refresh this PowerPivot. Not a solution but hoping to join the conversation to see if this helps come up with a solution.

 

 

J_K_
Level: Powered On

Re: Looking to Refresh an Excel workbook in a SharePoint Online DocLib

Hi @mnmsymmons 

thanks for your message. I want to do exactly what you have done in your second test. But it just does not work in my case. I don't know what makes the difference. 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 379 members 5,125 guests
Please welcome our newest community members: