Forum Discussion
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 months/years.
for example,
1. we want the details if the DB have not been used for the past few months/years.
2. we want the details if the Table have not been done any transaction (DML) for the past few months/years.
3. We want the details when the DB is created and through in whick login this db has created
4. How many login account have been connected for each database.
Is it possible to get all the above details in the Power BI Dashboard..?
If i get all the above about the server and DB details, it will be helpful for the management to save the cost for not using databases.
5 Replies
gani_tpt , Chekc if the queries given here can help
https://www.mssqltips.com/sqlservertip/3171/identify-sql-server-databases-that-are-no-longer-in-use/
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.
Hi Anonymous
Thanks for your reply.
will it possible to get sample PBI Dashboard which showing above all.
Getting details of SQL tables and DB is easy. But, when we trying to get into PBI deshboard i am struggling to get all the details.
Can you pls. help to get all the details in sample PBI Dashboard.
Can anyone reply the above said queries.?
This is very very urgent.
Hi Anonymous ,
can you pls. help us to bring all the above details in the Power BI Dashboard..?
