How do i import the SQL database created date into PowerBI?

[ssze]

One of my data table in powerBI is read from a database. and i'm hoping to have a card next to the table created showing the database created date.

E.g. when i went to property through MS SQL server management studio i can see the created date was 9/06/2021.

Am i supposed to create a DAX to draw this into powerBI (if so, how?), if not, what would you do?

Thank you!

[v-xulin-mstf · Accepted solution]

Hi @ssze

You can import the table contains list of databases as:

SELECT name, database_id, create_date  
FROM sys.databases ;  

Here is the output:

For more information, please refer to:

https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-a-list-of-databases-on-an-i... 

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[parry2k]

@ssze here are few link I googled:

List all the databases on one SQL Server in the order they were created - Stack Overflow

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@ssze it should be  SQL question on how to get that metadata 

[ssze]

Thank you @parry2k  do you have some tips on how i can do that?