Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi PBI'ers,
Could anyone specify how I can integrate a web api(Active demand) in PowerBI?
Here's a reference for the specific API:
https://support.activedemand.com/support/solutions/articles/5000539684-the-web-api-for-activedemand
Thanks already!
Kind regards,
MrNelsch
Solved! Go to Solution.
Hi,
Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.
You can write queries like below
SELECT * FROM $ LIMIT 25 WITH( src='https://api.activedemand.com/v1/forms.json?api-key={API_KEY}' )
Here is an article you can start with.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Check below link for more articles reklated to Power BI and Rest API Integration.
https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/
Hi,
Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.
You can write queries like below
SELECT * FROM $ LIMIT 25 WITH( src='https://api.activedemand.com/v1/forms.json?api-key={API_KEY}' )
Here is an article you can start with.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Check below link for more articles reklated to Power BI and Rest API Integration.
https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |