cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ssze
Helper I
Helper I

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

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?

ssze_0-1623271677511.png

 

Thank you!

1 ACCEPTED SOLUTION
v-xulin-mstf
Community Support
Community Support

Hi @ssze

 

You can import the table contains list of databases as:

v-xulin-mstf_1-1623740329696.png

SELECT name, database_id, create_date  
FROM sys.databases ;  

Here is the output:

v-xulin-mstf_0-1623740851947.png

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!

View solution in original post

4 REPLIES 4
v-xulin-mstf
Community Support
Community Support

Hi @ssze

 

You can import the table contains list of databases as:

v-xulin-mstf_1-1623740329696.png

SELECT name, database_id, create_date  
FROM sys.databases ;  

Here is the output:

v-xulin-mstf_0-1623740851947.png

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!

View solution in original post

parry2k
Super User III
Super User III

@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.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors