Forum Discussion

fernando89's avatar
fernando89
New Member
3 years ago
Solved

Authenticating and Connecting Power BI to API

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!

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 And Power BI M Code (crossjoin.co.uk)

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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 And Power BI M Code (crossjoin.co.uk)

    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