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) A...
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

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