If a column1 contains specific text, give me output from the list on another column

[Akhil_0101]

Hi,

I'm currently working to learn Power BI in order to build a reporting dashboard. I have health status report (CSV file) of my 3 servers which are located in 3 different regions and I want to visulize them on MAP in power BI. There is no location column or detail in status report so I want to create a location colum in query editor which will give me location name based on the server name. Which DAX function would be usefull in this scenario? Please help.

[edhans]

As far as I know, there is no way to get the server name or database name, or table name for that matter, of data you are connecting to. That is metadata above the level of the Query. You'd have to use Parameters or variables to pass through to the functions that call the databases, tables, etc. and then also evaluate those parameters or variables separately, but there is no function inside a query that can say "what server/database/table/view is this data coming from?"