USing REST API Data As souce

[pavan1]

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

[Anonymous · Accepted solution]

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

[ironryan77]

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?