Forum Discussion
Figuring out what Datasource a Dataset is using...
We are in the process of rolling out Power BI to our organization and we are using a gateway to connect to our on premise Analysis Services instance. Under the gateway we have setup two data sources,...
Hi dge7009
One way that you could possibly get it to work is to create a Parameter (Server Name) which will be the Server Name.
Then in your Source you can change it from entered Text to a Parameter (Server Name). This will allow you to easily change between DEV and PROD.
Then what you could then do is to create a table which will show you the current Parameter Value. Create a Blank query and put in the following into the Advanced Editor. As with my Example below, my Parameter was called "Server Name" and in the code below the "MyServername" is the column name.
let
Query2 = #table({"MyServerName"},{{#"Server Name"}})
in
#"Query2"Once this loads you will then have your parameter as a table. Which means you can then use this data in your report to show you which Server Name as you would with any other data.
Hey there Guavaq. I hope all is well. This is an interesting suggestion. Do you know offhand if it will work if we are using a live connection to a multidimensional AS cube? I feel like we have noticed that parameters aren't an option for live connections but I'm still pretty new to Power BI so I might just be missing it.