Forum Discussion
Error not specified refreshing MS Access data set
Hi community!
Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set:
Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****.
URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77
Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa
Hora: 2024-12-03 14:51:11Z
As you can see the details are "not specified" or "unknown"
There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.
Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).
Any suggestions?
5 Replies
- DavidSVCRegular Visitor
Hi community!
Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set:
Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****. URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77 Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa Hora: 2024-12-03 14:51:11ZAs you can see the details are "not specified" or "unknown"
There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.
Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).
Any suggestions?
- DavidLaytonNew Member
Hi everyone!
Since a couple of days, I'm getting a failure message upon refreshing a MS Access data set:
Error del origen de datos: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Error no especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"*******.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: *****. URI de clúster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net Identificador de actividad: df76499f-c0b5-4092-97e8-7d8c4456ea77 Identificador de la solicitud: ba0e4918-3b4a-7be6-642c-0b666f84f4aa Hora: 2024-12-03 14:51:11ZAs you can see the details are "not specified" or "unknown"
There seems to be an error related to Data Format. However, I tried refreshing a super reduced version of the report with just one table and a few rows and I keep getting the same error.
Not long ago, we updated on premise gateway version to 3000.246.5 (Nov 2024).
Any suggestions?
- lbendlinSuper User
Do you remember the previous gateway version?
(you probably know that .mdb is positively ancient. It requires a special 32 bit driver and has lots of locking issues. If you can, move to something a little fresher.)
- DavidLaytonNew Member
Hi lbendlin,
Previuous version was August 2024 update (3000.234).
I've searched the code -2147467259 and I found the following: "The HResult code -2147467259 is a generic error in Windows applications and translates to E_FAIL, which indicates an unspecified failure"
I know how bad can be working with Access... Unfortunately, I don't think migration will happen in the near future. I guess restarting the Access server won't hurt anybody.
Thanks
- AnonymousNot applicable
Hi QEDavidLayton ,
If you have a Pro license you can open a Pro ticket at
https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Best Regards