Forum Discussion

gani_tpt's avatar
gani_tpt
Regular Visitor
2 years ago

How to get all SQL Database with details information through Power BI Dashboard.

Currently we are using many servers and every servers is connected to "n" number of databases. Due to cost optimization,my company has decided to remove for not using database's for the past few mon...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi gani_tpt ,

Please try the following methods and check if they can solve your problem:

1.Leverage SQL Server auditing features to track access and modification dates. View the following link which help identify unused reports.

Find and retire unused .rdl reports - Power BI | Microsoft Learn

 

2.Query the system catalog views in SQL Server. Information about when a database was created can be found in the sys.databases.

 

3.It is possible to integrate the details into a Power BI Dashboard. Connect to SQL Server and use SQL queries to fetch the required information.

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gani_tpt's avatar
gani_tpt
Regular Visitor
2 years ago

Hi Anonymous ,

can you pls. help us to bring all the above details in the Power BI Dashboard..?