Connecting to API

Question

Hi Team,&nbsp;I am new to Power BI kindly help how to connect to API to start the data extraction and data model.&nbsp;RegardsGR

magnussthlm · Answer

Hi!&nbsp;What kind of API do you need to connect to?

gracerashmi · Answer

Need to coonect to Json API with input parameteres

magnussthlm · Answer

Hi!&nbsp;Go to Query Editor, choose "New Source" -&gt; "Blank Query". Enter your url to your json something like this:&nbsp;= Json.Document(Web.Contents("https://yourjsonurl.com/parameter"))&nbsp;Then you need to click List and transform into table, select what fields you want. Finally rename Query1 to something else.&nbsp;&nbsp;

gracerashmi · Answer

url:&nbsp;https://MyUrl/REST/mylinkinput parameter:{ "ServiceName":"GETTicket", "objCommonParameters":{ "_ProxyDetails":{ "Password":"test@123", "UserName":"test@domain.com", "ProxyID":0, "ReturnType":"JSON", "OrgID":1 }, "CallerMobileNo":"91XXXXXXXX", "CallerID":"2", "TopIncident":5 } }&nbsp;how do i execute this code. can any1 plz help on this

gracerashmi · Answer

url:&nbsp;https://MyDomain.com/REST/MyURL&nbsp;Input Parameter:&nbsp;{ "ServiceName":"GetTicket", "objCommonParameters":{ "_ProxyDetails":{ "Password":"test@123", "UserName":"test@domain.com", "ProxyID":0, "ReturnType":"JSON", "OrgID":1 }, "CallerMobileNo":"91XXXXXXXX", "CallerID":"2", "TopIncident":5 } }&nbsp;how to execute and connect to api

Forum Discussion

Connecting to API

6 Replies

Related content

New API connection

Query for Salesforce API connection

Connecting Power BI to Deltek Vantagepoint API

API Connection Question

Create Gateway Connection - API