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

[izz_faas]

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:

[hmasim_]

Hi @izz_faas  are you able to resolve the issue? Facing the same problem. My power automate copy the corrupt file on one drive

Many thanks

[anjanav]

Any solutions to this issue?

[anjanav]

Any solutions to this issue?

[GilbertQ]

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?

[izz_faas]

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.

[GilbertQ]

Hi @izz_faas 

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

[izz_faas]

Okay, here is my new flow:

Here is my error message:

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

[GilbertQ]

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?