Dynamically get database name in Power BI

Analitika — Tue, 07 Jun 2022 09:11:27 GMT

I would like to ask how to get database name dynamically and add it as a new column in the table.

Re: Dynamically get database name in Power BI

Hariharan_R — Wed, 08 Jun 2022 11:34:29 GMT

Hi,

If you use parameter to store the Servername and DBname then you can refer the parameter in the new column to get the database name.

If you use SQL server then you can use below script in new query and get the database name.

let
Source = Sql.Database("ServerName", "AdventureWorks2019", [Query="SELECT DB_NAME()"])
in
Source

Thanks

Hari