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 

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.

  • gani_tpt's avatar
    gani_tpt
    Regular Visitor
    2 years ago

    Can anyone reply the above said queries.?

    This is very very urgent.