No able to do Power Bi schedule refresh for Mongodb odbc

[Rohanbhowmick]

Hi

I have connected my Powerbi desktop with Mongodb Odbc and created some visuals and published in Powerbi Service while creating the Gateway connection on Powerbi I am giving the credential of mongodb atlas but the powerbi throwing error says like Inaccessable to data sets and not able to give the credential then I have skipped the login part in Gateway connection and build the gateway.

Now the problem occures that schedule refresh is not working and throwing this 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":"The given credential contains a property with a null value. Data source kind: Odbc. Property name: Username. "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: urlshortens.

Please need help on this

[lbendlin]

You need to get the ODBC connection to work on all your gateway cluster members. It requires you to login on each of them.

[Rohanbhowmick]

Can you please elaborate this please

[lbendlin]

On each cluster member open the ODBC 64 BIT control panel and confirm that the connection tests successfully.