web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Custom Connector not w...
Power Automate
Unanswered

Custom Connector not working

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Michael Shen Profile Picture
    on at

    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.

  • srduval Profile Picture
    1,760 Moderator on at

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard