Forum Discussion

toovishant's avatar
toovishant
Helper II
1 year ago
Solved

What details required to connect REST API to Power BI

Hi All,

Here are the Rest API details I have and unable to connect, not sure I follow the rest steps to connect. Please help.

curl -X 'GET' \  'https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000' \  -H 'accept: */*' \  -H 'x-api-key: ---------------' 

 Any help apperciated.

Thank You

Vishant

Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Hi toovishant 

     

    click get data > blank query > advanced editor > copy and past the following code and fill it up with the url and api key > click edit credentials > pick Anonymous > connect and see if it works ? 

     

    let
    Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
        [
            Headers = [
                #"accept" = "*/*",
                #"x-api-key" = "---------------"
            ]
        ]
    ))
in
    Source

     

8 Replies

  • kushanNa's avatar
    kushanNa
    Super User
    1 year ago

    Hi toovishant 

     

    click get data > blank query > advanced editor > copy and past the following code and fill it up with the url and api key > click edit credentials > pick Anonymous > connect and see if it works ? 

     

    let
    Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
        [
            Headers = [
                #"accept" = "*/*",
                #"x-api-key" = "---------------"
            ]
        ]
    ))
in
    Source

     

    • toovishant's avatar
      toovishant
      Helper II
      1 year ago

      You Rock My Friend kushanNa - It worked like a magic.

      I think there are other steps to get the data. Please can you proivde if possible.

       

      • kushanNa's avatar
        kushanNa
        Super User
        1 year ago

        No worries , click list > to table > ok > click expand column button and see if it expands the data ? 

         

        or try this code 

         

        let
    // Get the raw JSON
    Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
        [
            Headers = [
                #"accept" = "*/*",
                #"x-api-key" = "---------------"
            ]
        ]
    )),

    // Navigate to the "value" key which contains the list
    ValueList = Source[Value],

    // Convert list to table
    ToTable = Table.FromList(ValueList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    // Expand the records into columns
    Expanded = Table.ExpandRecordColumn(ToTable, "Column1", {"Name", "Value"})

in
    Expanded

         

  • Gabry's avatar
    Gabry
    Super User
    1 year ago

    Hey, what's your issue? M code should look like this:

     

    let
    url = "https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
    apiKey = "---------------",
    response = Web.Contents(url,
        [
            Headers = [
                #"accept" = "*/*",
                #"x-api-key" = apiKey
            ]
        ]
    ),
    json = Json.Document(response)
in
    json

    It should work

  • toovishant's avatar
    toovishant
    Helper II
    1 year ago

    I get the follow error when i try to use WEB and API key, I am using the right details to autheticate and connect API?