Add Power BI Dashboards For Data

[jacobgexigo]

Create Power BI reports from the data repository to allow for modern and customizable visualizations that could be shared via the .pbix file. This file could then be customized and published by anyone to their own PowerBI.com environments.

[jacobgexigo]

I am happy to get started on some mockups to see how this could be addressed

[DavidWiseman]

Hi that sounds like a good idea. I know a couple of people asked about Power BI for DBA Dash at SQLBits. I don't have any experience in this area so I wouldn't be able to take on the work myself. If you are able to take a look at it that would be great.

The GUI uses stored procedures for everything so you might be able to reuse some of these for Power BI. Here's a few examples:
dbo.CPU_Get
dbo.IOStats_Get
dbo.PerformanceCounter_Get
dbo.PerformanceCounterSummary_Get
dbo.Waits_Get
dbo.ObjectExecutionStatsSummary_Get
dbo.ObjectExecutionStats_Get

If you have any questions about anything, let me know.

Some additional background:

The user interface for DBA Dash started off with some SSRS reports. I later created a Windows GUI app to improve the user experience and add some functionality that wasn't possible with SSRS. There are definitely some trade-offs with a Windows GUI though - one of those been accessibility of the data. I'm guessing Power BI might help with that and is probably a better experience than SSRS. The old SSRS project is still in the repository if anyone wanted to use it or help maintain it. I've stopped working on it in favour of the Windows app though.

[PascoBOCC-JasonBoswell]

I am happy to get started on some mockups to see how this could be addressed

Have you been able to make any headway with Power BI dashboards?

[Jacob-Krueckl]

Just going to chime in and say that this is a great idea and would be extremely helpful in our use-case of DBADash.

We have many clients that we help monitor their systems and being able to provide them a report on request has been a challenge.

Theoretically we could create a SQL account that has access to only their statistics and expose our server to their network but then they would have set up the GUI. If I could view a dashboard and forward it to them then that would be VERY helpful!

[DavidWiseman]

Just going to chime in and say that this is a great idea and would be extremely helpful in our use-case of DBADash.

We have many clients that we help monitor their systems and being able to provide them a report on request has been a challenge.

Theoretically we could create a SQL account that has access to only their statistics and expose our server to their network but then they would have set up the GUI. If I could view a dashboard and forward it to them then that would be VERY helpful!

Thanks for the additional data point. This is a popular request. At the moment I'm not using Power BI for anything and I have zero experience with it. That could change in the future, but if anyone is interested in contributing PBI reports for DBA Dash I would consider pull requests.