Forum Discussion
Figuring out what Datasource a Dataset is using...
Hi dge7009,
Currently, I haven't found a valid solution that allows us to know the actual data sources behind data sets.
By the way, whay did you mean 'go with two gateways one for DEV data sources and one for PROD data sources'? Did you mean configure more than one on-premise data gateway on the same Windows server? If so, it is impossible as the on-premise gateway runs as a windows service called "PBIEgwService" on the server where it is installed.
Regards,
Yuliana Gu
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.
