Connecting CSPro database with Power BI

Discussions about creating CAPI applications to run on Android devices
Post Reply
rajeshwar333
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.

htuser
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

Hello,
It's very easy right now with the 7.5 release. You must use MySQL/MariaDB connector:
https://community.powerbi.com/t5/Power- ... d-p/195060
https://docs.microsoft.com/en-us/power- ... 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: https://github.com/IstatCooperation/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