Error not specified refreshing MS Access data set

[QEDavidLayton]

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?

[v-zhouwen-msft]

Hi @QEDavidLayton ,

If you have a Pro license you can open a Pro ticket at

https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

Best Regards

[DavidSVC]

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?

[DavidLayton]

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: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?

[lbendlin]

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.)

[DavidLayton]

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"

HRESULT Values

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