Connecting to API

[gracerashmi]

Hi Team,

I am new to Power BI kindly help how to connect to API to start the data extraction and data model.

Regards

GR

[MagnusSthlm]

Hi!

What kind of API do you need to connect to?

[gracerashmi]

Need to coonect to Json API with input parameteres

[MagnusSthlm]

Hi!

Go to Query Editor, choose "New Source" -> "Blank Query". Enter your url to your json something like this:

= Json.Document(Web.Contents("https://yourjsonurl.com/parameter"))

Then you need to click List and transform into table, select what fields you want. Finally rename Query1 to something else.

[gracerashmi]

url: https://MyDomain.com/REST/MyURL

Input Parameter: 

{ "ServiceName":"GetTicket", "objCommonParameters":{ "_ProxyDetails":{ "Password":"test@123", "UserName":"[email protected]", "ProxyID":0, "ReturnType":"JSON", "OrgID":1 }, "CallerMobileNo":"91XXXXXXXX", "CallerID":"2", "TopIncident":5 } }

how to execute and connect to api

[MagnusSthlm]

This link might help you:

https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

[gracerashmi]

url: https://MyUrl/REST/mylink

input parameter:
{ "ServiceName":"GETTicket", "objCommonParameters":{ "_ProxyDetails":{ "Password":"test@123", "UserName":"[email protected]", "ProxyID":0, "ReturnType":"JSON", "OrgID":1 }, "CallerMobileNo":"91XXXXXXXX", "CallerID":"2", "TopIncident":5 } }

how do i execute this code. can any1 plz help on this