topic Re: Data source authentication - two connectors in Developer

Data source authentication - two connectors

MarkusEng1998 — Mon, 15 Apr 2024 15:52:49 GMT

My data source authentication with the dRofus REST API is broken. This only occurs on a single PowerBI dashboard using this API. When I contacted the vendor, they suggested that it could be a conflict with another connector: Autodesk Construction Cloud.

The dRofus authentication broke after I added a new connection to the Autodesk Construction Cloud. Both dRofus data source and Autodesk use the same login. Is this the issue?

I am wondering if there's an error in using identical logins for different connectors?

Thank you for any suggestions.

Re: Data source authentication - two connectors

Anonymous — Tue, 16 Apr 2024 09:36:11 GMT

Hi @MarkusEng1998 ,

Ensure that both connectors are properly set up with login credentials such as username/password or any other authentication method.

Authentication issues may also be related to the way the token is refreshed. Make sure that the refresh mechanisms of both connectors do not interfere with each other.

Do you notice any specific error messages in Power BI when authentication fails in dRofus connector, if so, share them for further troubleshooting and we can help you better!

This is the related document, you can view this content:

How to Authenticate a REST API in Power BI? - Microsoft Fabric Community

Trusted Third-Party Connectors in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data source authentication - two connectors

MarkusEng1998 — Wed, 17 Apr 2024 16:10:47 GMT

Thank you @Anonymous for your response.

When I refresh the query with the dRofus API, the update window shows that PowerBI is waiting for the API.

After a couple of minutes (server timeout?) I get the can't authenticate message.

What is unusual is that I set up the data source with basic authentication, but the error returns as anonymous.

Because this is the only dashboard that is having the authentication issue with the dRofus API, I am resigned on removing the dRofus API query, and replacing it with an Excel export from dRofus instead.

Thank you for your consideration.

Markus.