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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tanaka
Frequent Visitor

Refresh Error : The file or directory is corrupted and unreadable.

Hi,

Well, since past week i am receiving the following error while refreshing a dashboard : 

 

Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Gateway_GatewayCorruptedFileOrDirectoryError","pbi.error":{"code":"DM_GWPipeline_Gateway_GatewayCorruptedFileOrDirectoryError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The file or directory is corrupted and unreadable.\r\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147023504"}}],"exceptionCulprit":1}}} Table: Base_Dash.

Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net

ID da atividade: 12508b75-969a-47a9-afb3-2a55ef7c35f0

Solicitar ID: d9420f0b-3e85-4637-9049-45ff3f6eed58

Hora: 2024-03-19 14:07:30Z

 


I am using the On-Premises Gateway installed at an Amazon Workspaces in order to update my published dashboards. 

All dashboards use data from either SQL Server or AWS Athena , i have already refreshed a dashboard from the PBI Desktop installed at this Amazon Wokspaces machine, just to make sure that the machine has access to those databases. 

I already reinstalled the gateway and recreated the gateway connection from PBI Online. I can't extract the gateway log files. 
And the most random thing is that some dashboards are still updating without any error, but the majority are suffering from this.

I wish to know if someone may help me or has already faced this kind of error before.

Regards, 
Tanaka.

2 REPLIES 2
v-tangjie-msft
Community Support
Community Support

Hi @Tanaka ,

 

Here are some steps you can take to troubleshoot this issue:

1. Ensure File Accessibility: Make sure that the file is not being used by another process during the scheduled refresh. It's recommended to save and close the file when the refresh is running.

2. Check File Path: Verify that the path of the file is correctly configured on the Power BI service. Incorrect paths can lead to refresh failures.

3. Refresh Timing: Consider setting the refresh time during off-peak hours to avoid conflicts with other operations that might be accessing the files.

4. Gateway Access: Confirm that the On-Premises Gateway can access and read the file.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

i have already checked these steps, but still receiving errors.

Using sp_whoisactive at SQL , i'm able to see that the refresh request is working properly, but maybe after or while the query is in progress the error occurs

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.