Page 1 of 1

Connecting CSPro database with Power BI

Posted: September 3rd, 2020, 8:19 am
by rajeshwar333
Hi everyone

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

Re: Connecting CSPro database with Power BI

Posted: September 3rd, 2020, 10:36 am
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.