Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost 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.

Need Help

1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution 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