Forum Discussion

pavan1's avatar
pavan1
Helper I
9 years ago
Solved

USing REST API Data As souce

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's avatar
    Anonymous
    9 years ago

    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

2 Replies

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      ironryan77
      Kudo Commander

      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?