Skip to main content
cancel
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.

Reply
izz_faas
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:

izz_faas_0-1701118680880.png

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:

izz_faas_1-1701118764748.png

The Power Automate flow looks like this:

izz_faas_2-1701119519671.png

 

izz_faas_3-1701119589284.png

izz_faas_4-1701119649833.png

The SharePoint file looks like this:

izz_faas_5-1701119747327.png

 

7 REPLIES 7
anjanav
New Member

Any solutions to this issue?
anjanav
New Member

Any solutions to this issue?
GilbertQ
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:

 

izz_faas_0-1701207462271.png

 

and here is the error message I recieve: 

izz_faas_1-1701207517120.png

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:

 

izz_faas_0-1701271368654.png

 

izz_faas_1-1701271391120.png

 

Here is my error message:

izz_faas_2-1701271459762.png

 

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

Announcements
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

PBI_APRIL_CAROUSEL1

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