Forum Discussion
Dynamic Database selection from Dashboard/Report
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.
Hi AlexisOlson,
Thank you for your suggestion. It took me a while to find what you were referring to but yes, this can be done by editing the query on the Power BI portal/website. I am currently working with Microsoft to see if there is a more user firendly way this can be achieved. I will hopefully have a solution next week but, when switching databases on the query, you also need to switch the Gateway connection too because the gateway connect the Power BI site to the on-premise data. You might be surprised by this but, when I change the DatabaseName Parameter Value, the Power BI Site also automatically changes the gateway being used in the Query (as long as the gateway Data Source has been pre-configured).
Hope to have a full solution to post next week.
