topic USing REST API Data As souce in Developer

USing REST API Data As souce

pavan1 — Thu, 26 Jan 2017 04:29:23 GMT

HI All,

When selecting source as rest api data,i get response able to see the output,but converting into a table getting the

following error .could please help any one how do you resolve the following error.

PUBLIC API LINK:http://services.groupkt.com/country/get/all

ErrorName:

Regards,

J Pavan

8801262055

Re: USing REST API Data As souce

Anonymous — Mon, 30 Jan 2017 09:05:20 GMT

Hi @pavan1,

Do you want to get the following query in Power BI Desktop? If so, please check the attached PBIX file to get more details about how to extract data from your data source.

Thanks,
Lydia Zhang

Re: USing REST API Data As souce

ironryan77 — Wed, 15 Mar 2017 16:36:44 GMT

Lydia, this is neat, but how did you create this PBIX file? I see that the Data Source settings contain a JSON object, but in my PBIX files they all use SQL tables. Can you post the steps for how to source a JSON query in Power BI?