Hi everyone
Can you plz share how CSPro database can be connected to power BI for period database updation on its own.
Connecting CSPro database with Power BI
Re: Connecting CSPro database with Power BI
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.
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