Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Would like to know the appropriate way of connecting Power BI Desktop to Apache Couch DB hosted in cloud to visualise data ? Since there are no drivers from Couch DB and not much resources regarding the same, finding it difficult to connect. Please suggest the ideal way of connecting and also let me know if its possible to schedule auto-refresh once the reports are built.
Thanks
@Vivek3492,
Based on my reserach, you are able to use Apache CouchDB API to get data. In Power BI Desktop, you can use web connector to connect to the API and then create report. After that, you are able to publish report to Power BI Service and set schedule refresh for the dataset.
About how to use Apache CouchDB API to get data, please review the official articles.
http://docs.couchdb.org/en/2.1.2/api/index.html
https://couchdb.readthedocs.io/en/latest/api/ddoc/views.html
Also there is another similar blog about how to use API to get data from Couchbase server for your reference.
Regards,
Lydia