Dynamic DB name

[Anonymous]

Hi,

How to show dynamic database name in card visual? if it's Dev then DBname_Dev, if it's staging then DBname_Staging and same goes to prod as well. 

Regards,

Venkat

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

One of the most straightforward workaround is to add another column "DBname" to identify the database for  tables in each database.

You also can  check if the solution in this thread works for you.

https://community.powerbi.com/t5/Power-Query/Dynamically-retrieving-the-DB-name-from-the-source-in-a-column/m-p/1310317 

Best Regards,
Community Support Team _ Eason