Sourcing Reporting Services Output in a Data Model
Does anyone know if it is possible to use an SSRS output (CSV, XML, or Excel) as a source in a Data Model? We tried to use the URL option without luck but aren't sure if it is a security problem or what.
Here is the basics of the call we are trying to use:
https://<My_Server>/ReportServer/Pages/ReportViewer.aspx?/Prod/COVID19&rs:Command=Render&rs:Format=CSV
When calling that URL, it immediately downloads the file locally. Can it be harnessed to go straight into a Data Flow?
If this is not possible due to the manner in which SSRS transfers the file, does anyone have an idea of how it might be accomplished using some other method like Python or something else?
-
Hi,
If SSRS does not allow to read the data with out downloading the file, you need to check the SSRS documentation, than you can consider the following.
You can check how SSRS based data can be consumed in an ETL process.
1. Run a process that downloads the SSRS based data into a file/s on a folder you have access to.
2. Run a process that reads the data from the file/s in to the model.
-
Michael Raam Thanks, Michael. I can certainly look at building a process around downloading the file and then using standard Data Flow features to pick up the file and importing it into a model. I was hoping I wasn't the first to try this so I could leverage someone's solution but sounds like I am blazing the trail
-