Import api data

[BabuG]

Hi, I need a help to import data such us schools, MRT  from onemap API  into power BI tables. Seeking guide for this query. Thanks in advance.

[v-jingzhang]

Hi @BabuG 

The following articles have some examples that may be helpful. You can get some ideas from them. 

Getting Started with API's in Power Query • My Online Training Hub

Read API Data with Power BI using Power Query (mssqltips.com)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[lbendlin]

Consult the documentation of your onemap API to understand how you should formulate your Web.Contents  requests in Power Query.

Web.Contents - PowerQuery M | Microsoft Docs

[BabuG]

Thanks for steps. Let me try it out.