Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

PM777

PowerBI Report failed to refresh on Refresh Schedule since 8/21/2023

Submitted by on ‎08-22-2023 02:14 PM

We have had report created and set on a weekly or daily refresh schedule for months now and refreshes were looking great until recently.

 

Ever since Monday 08/21/2023, our reports have failed to refresh on the schedule while throwing this vague error: "File contains corrupted data" when prompted to refresh by on-demand in PowerBI service.

 

However, when trying to refresh the tables in PowerBI Desktop, various errors occurs:

1. This process cannot access this file because it's being used in another process -- We have already confirmed that our file is closed.

2. Query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. -- When we set our privacy levels to the correct setting, it goes back to "This process cannot access this file because it's being used in another process"

 

These reports fail to refresh on schedule and on demand but nothing has changed on our end.  Our file is still being exported in the same format with the same same columns and with no change.  We discovered a workaround in that if we open the excel file and save it, then the report can refreshed on demand in PowerBI Service and in PowerBI Desktop, but this isn't really helping us with automating reports. Additionally, if we individually right click each table and click on refresh data, all the tables refresh without any issues and without needing to save the excel file.  

 

Is there something wrong with PowerBI updating the tables that have the same source file in parallel because when I load Table 1 from Source A, then the file can load and refresh, When I load Table 2 that uses the exact same source (Source A), then it will load, BUT then, once I hit refresh ALL, then I get this error: This process cannot access this file because it's being used in another process

 

Status: Accepted
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎08-23-2023 02:34 AM

Hi @PM777 ,

 

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses