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!

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Copy this JSON and check with the online JSON formatter. is the format correct ?

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
      4 years ago

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

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

        Hi  Anonymous ,

         

        Glad to help.

         

        Best Regards,
        Kelly

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