Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone, I'm diving into the world of Power BI now looking to connect it with a CRM we use at work and create live data dashboards from it.
Here's the link for this application (called MYP) API documentation: https://developer.mypcorp.com/art/overview/
For the authentication, I've started following the steps on: https://developer.mypcorp.com/art/authentication/ but in one of the very first steps it asks for an 'Organization URL' to generate keys. Would this be a Power BI generated URL?
If anyone can point me in the right direction and/or to resources where I can refer to to learn the basics of this first stage (getting them connected) it will be great, thanks in advance!
Solved! Go to Solution.
Hi @fernando89,
It suppose it may mean the front part of request URL, you can take a look at the following link and sample codes about use web.content to getting data from API with relativepath option:
let
url = "https://developer.mypcorp.com/",
body = "{}",
token = "xxxxxxxx",
header = [
#"Content-Type" = "application/json",
#"Authoritation" = "Basic " & token
],
response = Web.Contents(url, [
RelativePath = "art/authentication/",
Headers = header,
Content = Text.ToBinary(body)
]),
AccessToken = Json.Document(response)[access_token],
JsonResponse = Web.Contents(
url,
[
RelativePath = "xxx/xxx",
Headers = [
Authoraztion = "Basic " & AccessToken,
#"Content-Type" = "application/json"
]
]
),
Result = Json.Document(JsonResponse)
in
Result
Regards,
Xiaoxin Sheng
Hi @fernando89,
It suppose it may mean the front part of request URL, you can take a look at the following link and sample codes about use web.content to getting data from API with relativepath option:
let
url = "https://developer.mypcorp.com/",
body = "{}",
token = "xxxxxxxx",
header = [
#"Content-Type" = "application/json",
#"Authoritation" = "Basic " & token
],
response = Web.Contents(url, [
RelativePath = "art/authentication/",
Headers = header,
Content = Text.ToBinary(body)
]),
AccessToken = Json.Document(response)[access_token],
JsonResponse = Web.Contents(
url,
[
RelativePath = "xxx/xxx",
Headers = [
Authoraztion = "Basic " & AccessToken,
#"Content-Type" = "application/json"
]
]
),
Result = Json.Document(JsonResponse)
in
Result
Regards,
Xiaoxin Sheng
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |