Issue with refreshing semantic model with datasource conbected through gateway

[Anonymous]

Hi all,

recently we started getting this error on all of .mdb files located on out on-premise server, to with we setup connection through gateway.

This happens when trying to refresh semantic model on app.powerbi web. We are reallyl out of ideas - no thing really changed and this started only after around 20 december.

Any ideas? Surely its not an network error as files readily avaible and can be opened in access or powerbi desktop. Also credentials are correct (i tried creating new connnection with new credential but error is the same)

• Data source error{"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":"Unspecified error"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"IE0313373 BMS.mdb"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: FACT_1200_linereport.
• Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
• Activity IDa101dc50-2b85-4704-b254-395a956ea7a7
• Request ID4561c518-f56f-c272-8600-b6839e176e05
• Time2024-01-04 20:34:02Z

[lbendlin]

{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: FACT_1200_linereport.

You didn't change the data format of a column in that table?

[Anonymous]

Nothing was changes as far as i know - similar errors happen on at least 3 access files. I even tried to convert from .mdb to newer format but that did not change anything. Tried also putting this files on different server - also no change.

[lbendlin]

In general you should try to avoid using Access (and especially .mdb format)  for your data storage.   Do you have an option to migrate your data to SQL Server?

[Anonymous]

Hi  @Anonymous ,

Please make sure your gateway version is up to date that the gateway can reach the data source server. If the server is unreachable, consider restarting it.

You may also verify the report has a gateway selected. If there is no gateway selected, the data source might have changed or might be missing.

If none of this works. you may consider the issue is not caused by firewall restrictions,try launching the on-premises data gateway application and ensure the HTTPS mode is off.

Some users have reported that rebooting the server where the gateway is installed resolved the issue.

Solved: DM_GWPipeline_Gateway_MashupDataAccessError - Microsoft Fabric Community

Best regards.
Community Support Team_Caitlyn

[Anonymous]

Disabling https is an option we are taking in consideration - but it will need to be done through change request so its not quick in our case.

I tried to use ODBC connector, and while it works if i only import few tables from database; when i import all ~50 i get this error when trying to refresh on app.powerbi:

• Data source error{"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":"ODBC: ERROR [08004] [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.\r\nERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dbq=\\\\IECORFPS005\\Projects\\DePD\\Projects\\Test\\Refresh_Test\\IE0313231 IDLrefresh.accdb;driver={Microsoft Access Driver (*.mdb, *.accdb)};dsn=MS Access Database"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: _tbl_PIPE_bak.

Too slow connection in this case? Especially this part is new error:

Too many client tasks.\r\nERROR