Authenticating and Connecting Power BI to API

[fernando89]

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!

[Anonymous · Accepted 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:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

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