Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue with refreshing semantic model with datasource conbected through gateway

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 mo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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