cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBI Connector Unauthorized

fredsnertz
Deputy Chef I
Deputy Chef I

I'm attempting to connect to a trial PowerBI account.  There is a Community connector but I'm not seeing much documentation for it.  I believe I have set things up properly but I can't get the connector to connect.  I am attempting to use OAuth2 Client credentials and I continually get the error:

Connection failed
401 Unauthorized: at line: 185

If I mess up the client secret, the error changes to  "Invalid client secret provided" which tells me that my Client ID, Secret, and Tenant ID are all valid.  Is it the permissions on the Application in Azure?  Not sure how to troubleshoot this one.  Thanks.
3 REPLIES 3

julie-reyes
Workato employee
Workato employee

Hi, 

Good day!

There are hints below the fields on how to get the Client ID, Secret, and Tenant ID. Please follow the instructions indicated inside it.

You can also follow this step-by-step guide to getting the Client ID, Secret, and Tenant ID in PowerBI:

 

Where to find your Client ID, Client Secret, and Tenant ID on Power BI

  • From the Azure portal home page  > Navigate to App registrations.

juliereyes_9-1717165449139.png

 

  • Select the application. 

juliereyes_10-1717165477841.png

  • Note down the Client ID and Tenant ID (only required for single tenant authentication).

juliereyes_11-1717165493726.png

 

  • Navigate to Certificates & secrets from the menu bar at the side and note down the Secret ID.

juliereyes_12-1717165504061.png

 

 

Thank you

 

persifore
Deputy Chef I
Deputy Chef I

Hello, i have the same issue. Were you able to figure out a solution? thanks!

ndy
Deputy Chef III
Deputy Chef III

Dear @fredsnertz 
Could you share your screenshot?

Nguyen Duc Y