Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can connect Power BI software to redcap data? Please share any video or link of this.
Solved! Go to Solution.
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
Optional parameters you may pass are
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.
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
Optional parameters you may pass are
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.
Hi,
I have multiple REDcap surveys that I wish to display in a PowerBi dashboard. Custom connectors have been created but there are issues with refreshing of the data and currently we are having to download each survey and run the dashboard from the desktop location. Can someone assist in a relatively step by step of video manner to work through the problem being experienced? Thank you
To get the published report to connect to the REDCap data source via API and refresh in the service, you have to edit the data source credentials:
Authentication method = Anoymous
Privacy = Organizational
Skip test connection = TRUE
This last item was the key in my situation. It doesn't work if you test the data connection because there's no way to authenticate; the test always fails. The token embedded in the Power Query is all the authentication needed. That's why you skip test connection.
Thanks Yadong. Would it be possible to put an example in github of its use, plus any other relevant usage infomration. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.