Connecting CSPro database with Power BI

Discussions about creating CAPI applications to run on Android devices
Post Reply
Posts: 8
Joined: July 11th, 2020, 2:02 pm

Connecting CSPro database with Power BI

Post by rajeshwar333 » September 3rd, 2020, 8:19 am

Hi everyone

Can you plz share how CSPro database can be connected to power BI for period database updation on its own.

Posts: 482
Joined: December 19th, 2011, 6:26 pm
Location: HAITI

Re: Connecting CSPro database with Power BI

Post by htuser » September 3rd, 2020, 10:36 am

It's very easy right now with the 7.5 release. You must use MySQL/MariaDB connector: ... d-p/195060 ... qldatabase
and query the Target database where broken out questionnaire are stored in a relational database.
Except that this relational database doesn't have any valueset label..
To have label a workaround is to use CSPro2SQL: who's able to create a sql file with label (maybe, but not directly, in several languages if you have multi language dictionary).
Hope this help you.

Post Reply