rpowerbiredcap

Import pdf files from API into rows in Power Bi


I have a Power Bi Dashboard I've made that pulls its Data from a REDCap Database using an API. It looks like this, with mostly Text in the various columns:

enter image description here

What I'd love to do is make it so that thee fields circled in red were real files that could be clicked and downloaded. I know that the API allows me to pull files from it. I've used R with code like this (that individually mentions what record and field I want):

library(REDCapR)
redcap_download_file_oneshot( redcap_uri="https://redcap.company.org/redcap/api/", token="################", record="1", field='full_protocol_attachment_t_v2', event = "", repeat_instrument = NULL, repeat_instance = NULL, verbose = TRUE, config_options = NULL, overwrite = TRUE )

To individually download files one at a time. The problem is twofold:

So my question is: is there a way to do this directly within PowerBi? Like a calculated column or something that would pull a particular records file based on what row it was in?


Solution

  • The only thing you can do in native PBI is have a URL which when clicked will open the destination for you. Can you create a full url for the file download?