Forum Discussion

Post Prodigy

4 years ago

Dynamically get database name in Power BI

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

Solution Sage

4 years ago

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