Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Power BI refresh issues after a Power Automate run (saving an Excel file to SharePoint)

I'm getting this weird flow issue that I can't figure out.


The flow I have set up is:

  1. An email with an Excel attachment arrives in my inbox every morning at 7am
  2. The email triggers a Power Automate flow to save the attached file to SharePoint (it overrides the file from the previous day)
  3. I have a Power BI report that references the file in SharePoint.  The report is set to refresh daily at 8am (after a new file has been saved)

The issue:

Once the new file is saved to SharePoint by Power Automate, Power BI can no longer refresh with the new data.  I get this error message instead:


To fix the issue I just have to navigate to the SharePoint file each day after the Power Automate flow has been triggered and open the file.  Once the file has been opened after the Power Automate run, Power BI no longer has issues refreshing.  For the past several month, I have been going in and manually opening the file daily between 7 and 8 am, but would like to stop performing this manual step. 


I didn't always have this problem.  I set up this process a couple of years ago and it just started having problems several months ago.


The email looks like this:


The Power Automate flow looks like this:





The SharePoint file looks like this:



New Member

Any solutions to this issue?
New Member

Any solutions to this issue?
Super User
Super User

Hi @izz_faas 


It appears that for some reason the file when uploaded to SharePoint appears to be corrupted. What happens if you rather keep the files and replace the contents with your Excel file you receive to see if that works?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Thank you for your quick response and your recommendation.  In the end, however, that option did not work for me either.


Here is the new Power Automate flow:




and here is the error message I recieve: 


Once I open the file after the Power Automate flow, the Power BI refresh works.

Hi @izz_faas 


What happens if you first delete the data from the file and then insert it again?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Okay, here is my new flow:






Here is my error message:



Same as before.  Doesn't work until I open the file.


Hi @izz_faas 


That is weird.


The only other thing I can think of is what if you got the data in the Excel file and then saved it as a CSV?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors