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://---------------------/GetAllBuildingsPublicBa...
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

     

toovishant's avatar
toovishant
Helper II
1 year ago

Hey kushanNa  - What if I want to connect via the api key what details and steps required?

Should I go via the Connect data >Web>Web API

not sure what details need to enter in "Key", As mentioned earlier I have these details.

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

 

Thank You

 

kushanNa's avatar
kushanNa
Super User
1 year ago

To the best of my knowledge, the 'key' is typically used with a general header like 'Authorization', but in your case, you’re using a custom header like 'x-api-key'