Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Credentials are missing error - custom connector with Oauth2

I have a custom connector for the Exact online API (exactonline.com) which uses Oauth2 authentication.  This connector works correctly in Power BI Desktop. I want to use this connection in Power BI Services. 

 

Using the enterprise Gateway (I tried the personal gateway as well), I am able to (1) select my custom connector and (2) to get the pop-up screen of start.exactonline.com to insert my credentials. 

However, after logging in succesfully, when I click 'add' I get the following error:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: b863cc9e-7177-4f31-8081-1a47932d532a
Request ID: de4f7731-fe07-e5de-1b1b-f49d45c39ece
Cluster URI: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Mon May 18 2020 12:05:31 GMT+0000 (Greenwich Mean Time)
Service version: 13.0.13248.257
Client version: 2005.1.00976-train

 

I used to get the following error message in addition to the above message: "Credentials are missing or invalid". However, this is somehow no longer the case.

 

To be clear: I installed the enterprise gateway and the Custom Connector in an Azure VM. 

 

I have read a lot of community posts and found out that one of the following can be the issue:

1. Not all correct ports are open, for example the ports for Azure Service Bus. However, when I test the connection using the Enterprise Gateway wizard all necessary ports seem to be open. Is it possible that despite the testing I still have to open some ports? I doubt this because I am able to see the connector and besides I am able to insert my credentials. 

 

2. the domain of the rest api (in my case start.exactonline.nl) has to be whitelisted. However, I don't know how to whitelist this domain (my experience with whitelisting and firewalls is very limited). I'm sure this has to be done in the VM but I can't find a way to whitelist a domain (I don't have the IP adress). 

 

3. The test connection section has to be added in the custom connector program. This is added in the file but doesn't solve it. 

 

Any help is appreciated! I am wondering whether I am in the right direction with above suggestions. Maybe it is a whole other solution. 

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Kelly, 

       

      Thanks for your reply! The Gateway is installed in the Azure VM. Power BI Service is used outside of this environment. According to the documentation the gateway seems to be installed correctly. 

       

      I saved the custom connector in the folder NT SERVICE\PBIEgwService. Is it possible that this might cause the problem? 

       

      I tried my gateway connection with a csv file as input which was located on the VM This worked fine. However to make this connection to the csv file I had to insert my credentials for the Azure VM. I don't have to do this when I try to connect to the Custom Connector. Is it this part that needs extra configuration or something? It confuses me a bit that for a csv file I have to input the credentials to login to the VM and for a Custom Connector this is not necessary. 

       

      Best regards,

      Rens

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi Anonymous ，

         

        Is the folder  NT SERVICE\PBIEgwService kept on VM?In your customer connector,it may already save the credential of the data source,so it's no need to configure the data source again,but if in the gateway connection,there's no data source configuration,you need first to configure data source to make the gateway work.

         

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!