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

Modifying Vishal's Server SQL Info Dashboard

Hi all. I recently have looked at Vishals great sql server info power bi dash and thought it would be ideal for my needs.

 

https://community.powerbi.com/t5/Data-Stories-Gallery/Vishal-s-Server-SQL-Info-Dashboard/td-p/91812

 

Im not fully conversant with power bi yet so i'm wondering if theres anyway to tweak the queries on this dash so i could filter via server instead of it just listing info for the one i specify when creating the initial connection. I support around 40 servers and have them all in a CMS (Central management server) but i would love to be able to modify this dash so i had a drop down list of my servers and i could just pick one and it retrieves the relevant data.

 

Any ideas?

 

Thanks for looking.

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Modifying Vishal's Server SQL Info Dashboard


@addyb77 wrote:

Hi all. I recently have looked at Vishals great sql server info power bi dash and thought it would be ideal for my needs.

 

https://community.powerbi.com/t5/Data-Stories-Gallery/Vishal-s-Server-SQL-Info-Dashboard/td-p/91812

 

Im not fully conversant with power bi yet so i'm wondering if theres anyway to tweak the queries on this dash so i could filter via server instead of it just listing info for the one i specify when creating the initial connection. I support around 40 servers and have them all in a CMS (Central management server) but i would love to be able to modify this dash so i had a drop down list of my servers and i could just pick one and it retrieves the relevant data.

 

Any ideas?

 

Thanks for looking.


 

@addyb77

Since you're attempt to connect to around 40 servers, then you may have to create 40 * queries in that report. Then create a indicating "serverName" column for each query. Then append the queries of same info from different servers. Then in the report, you can use slicer to filter the visuals to show the selected server info.

 

For more flexibility, you can create an external console application that extract the required information for 40+ servers in a loop and save the info a csv/excel. Then chedule the application running in, say every 5 minutes. You only have to change the source of already existing queries from SQL SERVER DB to csv/excel.

 

The second approach would be more managable, however it would require some coding skill.

Highlighted
Helper I
Helper I

Re: Modifying Vishal's Server SQL Info Dashboard

Thanks for the reply. Yes i think multiple queries is my only real option based on my coding skills 🙂

I will give it some thought.

 

Regards

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors