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.
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.