Forum Discussion
How can connect Power BI software to redcap data?
Hi Rashid_Ali ,
Please refer to this link:GitHub - mandevuMan/REDCap_PowerBI_Connector
This is a custom data connector which you can use in Power BI to connect to your REDCap installation. The connector is able to get data from all types of REDCap projects including longitudinal and projects with repeat instruments.
You must pass the following parameters when connecting Power BI to REDCap- REDCap URL
- Project API Token
- Raw or Label data format
- Raw or Label headers
- Export Checkbox Labels
- Export Survey Fields
- Export Data Access Groups
Optional parameters you may pass are
- Fields
- Forms
- Events
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm struglling with connecting Power BI with Redcap database. I followed the steps (downloading and saving the GitHub code in the right folder). My problem is, the Redcap customer connetor is not popping up in Power Bi GetData. How can I solve this problem?
So you are going to 'Get Data' ... then 'More...' ... then in the search box on top left put in 'redcap' ...and that should bring up the redcap connector. If it is not there... something is wrong along the way.
