Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to add a new Auth2.0 API datasouce to my BI report, however I keep getting an error message says "We encountered an erro while trying to connect" "Details: "Web.Contents failed to get contents from 'https://aisegypt.powerschool.com/ws/schema/query/com.esol.essamx.googleworkspace.students/' (405): "
Attached some screenshots from the error and configuration I am using.
Could you please advise ?
Solved! Go to Solution.
I figured out by passing a blank content. 😀
Content = Text.ToBinary("")
Thanks for everyone.
I figured out by passing a blank content. 😀
Content = Text.ToBinary("")
Thanks for everyone.
Specifying POST won't help you . You need to provide a payload to switch the request from GET to POST.
Which method does your API expect?
It does expect POST method. kindly find belowall the details for preload.
POST https://YOURSERVER/ws/schema/query/com.mycompany.mydivision.student.studentnumber Accept: application/json Content-Type: application/json Authorization: Bearer xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
Read about how to use the Content option in Web.Contents()
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |