If you have a custom REST API and would want to Direct Query the API from Power BI instead of an importing data, this tutorial will guide you on how you can do that for any of your public or internal REST API’s.
To enable Direct Query for your REST API, the pieces of puzzle you need would be
- A Custom ODBC Driver for your REST API
- Power BI Data Connector that enables Direct Query
In this tutorial, I will be using REST API from NYC Open Data to demonstrate the Direct Query capabilities.