All,
I am having difficulty with one last requirement that our customers have asked and I am reaching out to you to, hopefully, know how you've successfully implimented my requreiement. How do you dynamically pass parameters into a report not knowing what parameters need to be passed in?
To give a little backstory, I (really, my team) have developed a report that will monitior SPC processes for all our products that we run. This Power BI report will be used as a dashboard that will update once new data has arrived. My team thinks that this will be used on hundreds of monitors across our company.
With that being said, we have three parameters - Plant, Line, & Machine. The report won't know what it is supposed to monitor when the report is launched and the dashboard could be moved within the plant.
I wondered how others have successfully conquered this problem. I am thinking that we'll have to do dynamic filtering via a third-party program like Visual Studio, and pass those filters to the URL and update the report.
I look forward to hearing your answers.
