Custom Connector not working

(0) Share

Report

Posted on by srduval

1,760 Moderator

@MBAS2020 #MBAS2020

I create a custom connector and have the app setup with azure, but I am unable to connect to power bi. not really sure what I'm missing I've used the swagger file from here:

https://raw.githubusercontent.com/microsoft/PowerBI-CSharp/master/sdk/swaggers/swagger.json

and as far as I can tell I have the proper connection oauth setup because the request returns an authorization token.

{
"Authorization": "Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IkN0VHVoTUptRDVNN0RMZHpEMnYyeDNRS1NSWSIsImtpZCI6IkN0VHVoTUptRDV {Intentionally Removed} X9YSwVVnR7i3SgP5Rfpap9vtxK-UK_rrwvT59aJcfbcS4N7AogaLHVvgf_eJVTJn46QBLZ2_IGBPAHTWaXoPdemNFIqfF-2jyZYOc-PJmssnqc04OKAjcL-JfRZNcsVjECs1KpCvkbz-hn6-cJM_w9Mq7Dm-rd68dLOEWZc0wnaw"
}

when I test the actions I get:

Operation failed (403), see response below

Headers:

{
"content-length": "0",
"date": "Thu, 07 May 2020 01:59:09 GMT",
"requestid": "24015489-0f23-4c55-a49d-86db70d77a0d",
"strict-transport-security": "max-age=31536000; includeSubDomains",
"x-content-type-options": "nosniff",
"x-frame-options": "deny"
}

Body is blank

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Michael Shen Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I don't have experience with pbi api.

But from my experience, in custom connector, the query parameter has different data type, correct data type may cause failure sometime.

Not sure if you have the good request & response called from browser or other clients.

If so, you may compare the request sent from your app and the good request.

That will be an efficient way to know what request data is wrong/missed.

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Michael_Shen_JT I think that's where my connector is broken, but not sure how to change it, trying to send a request to PBI to get workspaces and this is what is sent as the request, but it's not what I put i

This is the URL I put into the get verb request URL:
https://api.powerbi.com/v1.0/myorg/datasets

https://msmanaged-na.azure-apim.net/apim/xxxxxxxx-5f

https://msmanaged-na.azure-apim.net/apim/xxxxxxxx-5fpower-5fbi-5f1befd0a94f65e056-xxxxxxxxxxx/bc8cbf88-068d-497c-8671-5e37-8ae63d0e/v1.0/myorg/datasets/5b278952-4ce0-4333-8e7e-5b0995c342aa/refreshes

Was this reply helpful? Yes No