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
In this tutorial, I will be using REST API from NYC Open Data to demonstrate the Direct Query capabilities.
I hope this article helped you on how you can Direct Query your REST API using the ODBC driver built on Progress DataDirect OpenAccess SDK. All the Progress DataDirect ODBC drivers and the drivers you can build using OpenAccess SDK are fully compliant to ODBC standards, and are internally certified to work with Power BI. Feel free to try these for your projects and if you have any questions or issues, feel free to contact us.