Using Monkey Tools - No-code/Low-code SQL DMV Connections for Power Pivot!
Okay, let's be honest: SQL Dynamic Management Views (DMVs) aren't for everyone. But if you are in an area where you need to use them, you'll know that setting them up in Excel to query Power Pivot involves writing not only the SQL code, but also a VBA back end to apply them. At least - it used to. With this monkey at your side, you'll find data extraction from the Data Model via SQL DMVs is easy. Our DMV Sleuth builds the connection, and even provides you with a massive list of DMVs to query. All you need to do is customize the DMV to get the exact output you need!