Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Connect to REST API (Python-MongoDB)

Upon clicking the "Get Data" option and then clicking "Web" in PowerBI, I typed in my own REST API's URL (http://127.0.0.1:5000/players/all). Once I press connect, the following can be seen:  ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Import using Power BI Query Mode:  Select your DSN (after connecting using ODBC connector)and click Advanced Option to enter custom SQL Query to Import your REST API data. You can use ODBC DSN Data sources Preview tool to generate SQL Query. For example you can enter query like below. If you are not sure use Query builder (Found on Driver Preview Window)

    SELECT * FROM $
WITH(src='https://my-api-url')

     

    For  details,pls check below reference:

    https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMIzLjLqqTi8gIVAplmAh3vuQOUEAAYASAAEgI_8fD_BwE

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak , the format is correct, the online converter just beautfied it. 

 

Even if this format were to be wrong, I won't be able to change it as the API is taking data directly from MongoDB (which stores data in .json format)

Is there any workaround for this problem? Is/are there any other way(s) to solve this?

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  Anonymous ,

 

Import using Power BI Query Mode:  Select your DSN (after connecting using ODBC connector)and click Advanced Option to enter custom SQL Query to Import your REST API data. You can use ODBC DSN Data sources Preview tool to generate SQL Query. For example you can enter query like below. If you are not sure use Query builder (Found on Driver Preview Window)

SELECT * FROM $
WITH(src='https://my-api-url')

 

For  details,pls check below reference:

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMIzLjLqqTi8gIVAplmAh3vuQOUEAAYASAAEgI_8fD_BwE

 

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-kelly-msft. It worked. Thank you so much. 🙂

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi  Anonymous ,

       

      Glad to help.

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my reply as a solution!