Hi i was asked to help on an odd task today. One of our divisions keeps safety kpi's in a spreadsheet on some drive. The first tab looks like a dashboard and it gets its underlying data from another tab. Once the guy in charge opens it and enters any changes, days without an incident either starts back at zero or is incremented by 1. his assistant comes along to that drive, perhaps archives the file and then saves that dashboard as a pdf. Then she uploads the pdf to ssrs in a sub folder called resources(1). I dont know if resorces(1) was our name or some ssrs thing. either way, they will use sharepoint in the future for some or all of this. i'll probably ask that guy tomorrow why not leave the saved pdf on that drive where sharepoint can easily see it. But just in case, does the community have any ideas for automatically uploading a pdf to a specific folder in ssrs after its saved? Or maybe how that data tab can blow back into sql which maybe we can use to build an ssrs dashboard that gets hydrated from sql. thinking out loud here.
April 12, 2024 at 11:30 am
No doubt you've considered this, but wouldn't a more-streamlined process be to ingest the spreadsheet data in SSRS (or in Power BI) and build the dashboard there?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 12, 2024 at 12:47 pm
thx, just the type of feedback i was looking for. i've never seen an ssrs report ingest excel. But i am very familiar with pbi ingesting excel. do you have any links or starter steps for ingesting excel into ssrs?
thx, just the type of feedback i was looking for. i've never seen an ssrs report ingest excel. But i am very familiar with pbi ingesting excel. do you have any links or starter steps for ingesting excel into ssrs?
This link seems to cover it: https://answers.microsoft.com/en-us/msoffice/forum/all/setup-microsoft-excel-as-datasource-for-ssrs/139494df-8f14-4a40-913d-1b89b8cece0e
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply