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,...
Hey Yuliana. I hope all is well. Thanks for the follow up response and confirming my assumption that this isn't currently possible to see the data sources behind a data set from the service. As for the multiple gateways they are installed on separate boxes. One on our Dev box with all our Dev data sources and one on our production box with all our production data sources. It seems to be working well and we can at least verify we are using dev or production resources by seeing what gateway is being used.
Perhaps I will suggest this as an idea for product enhancement via the forum.
Thanks again!
Perhaps I will suggest this as an idea for product enhancement via the forum.
Thanks again!
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.