Forum Discussion
Dynamic Database selection from Dashboard/Report
Hi All, I am very new to Power BI and trying to find out if meet our needs. We currently have an on Prenmise SQL Server and have an extensive set of paginated reports built for our analysis. We...
At the very least, you can set up parameters in the query editor to quickly switch between data sources in the Query Editor.
For the end-user to be able to do this, I think you'd need DirectQuery with Dynamic M query parameters. This is pretty new though and I haven't tried it myself.
I should have mentioned that I have implemented a parameter in the underlying query based on some other forum posts. It just seems like the ability to set the parameter from within the dashboard is not available as a feature.
To be honest though, I haven't discovered how I would set the paramter when loading the dashboard so I still have to work that part out first. I just started installing the gateway so that I can use direct query too.