Connecting CSPro database with Power BI

Discussions about creating CAPI applications to run on Android devices
Forum rules
New release: CSPro 8.0
Post Reply
rajeshwar333
Posts: 10
Joined: July 11th, 2020, 2:02 pm

Connecting CSPro database with Power BI

Post by rajeshwar333 »

Hi everyone

Can you plz share how CSPro database can be connected to power BI for period database updation on its own.
htuser
Posts: 631
Joined: December 19th, 2011, 6:26 pm
Location: Silver Spring Area, MD, USA

Re: Connecting CSPro database with Power BI

Post by htuser »

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.
G.VOLNY, a CSProuser from Haiti, since 2004
Post Reply