Forum Discussion
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:
- An email with an Excel attachment arrives in my inbox every morning at 7am
- The email triggers a Power Automate flow to save the attached file to SharePoint (it overrides the file from the previous day)
- 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:
8 Replies
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.
- Any solutions to this issue?
- Any solutions to this issue?
