[PowerBI] Troubleshoot by analyzing the Waitstats/Perfmon counters deviation from standard values

[EmanueleMeazzo]

Do you want to request a feature or report a bug?
Yet another enhancement for PowerBI, two additional pages

What do you want to do?
Adding two pages to use the existing data for troubleshooting
Counters and Waitstats are good boys and useful for understanding what’s going on in your SQL instance, but often are pretty useless by themselves if you don’t know what’s a normal value for your server; For example a value of 100 batch requests/Sec is a value to worry about? It depends ¯_(ツ)_/¯

How?
Details here

Demo
Follow this link

[BrentOzar]

I'm having the same problem with this that I have with the measure in #1439. Power BI is reporting that the formulas in the blog post aren't valid:

[EmanueleMeazzo]

@BrentOzar I've tried to copy/paste these measures too, all works fine, it's maybe a character war between OSX and Windows

[BrentOzar]

OK, great, got it! Yeah, what I saw in the Power BI file doesn't match what I saw in your blog, so that must have been it. Wanna check out the files in the pull request? I'm stopping edits for today, so if you want to take these files and use them as a starting point for any changes you wanna make this week, that's fine - I won't make any other changes this week.