DAX Query View – More Scripts!!

This blog explains what are the other DAX scripts which can be considered as handy for you to understand the model and help you to optimize.

I have already shared couple articles for DAX Vertipaq Analyzer – Added those articles here for your reference.

Vertipaq Analyzer inside Power BI Desktop DAX Query View – Hari BI Academy

DAX Query View – Vertipaq Analyzer Scripts with URL support – Hari BI Academy

DAX Query View is a great feature in Power BI Desktop and service which opens up lot of possibilities.

Use the below scripts to understand the model summary, issues and measure dependencies. You can further extend for your requirements.

Get the scripts from my GitHub repo – Power-BI/DAX Query View at master · rhariharaneee/Power-BI · GitHub

Quick snippets of the scripts

Model Summary

It has property and value and then comment column holds the script to see the detailed information.

DAX Query URL for the Model Summary – Replace <WorkspaceID> and <SemanticModelID> with your workspace ID and model ID

https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIALTp1mcC%2F6VVW2%2BjOBR%2BTn6FxVOibUtnHldtJUrpDNqEMFwylyhaeYJ34i3BDDZJo9X%2B9znGkEAhCdI8hfhcvuPv%2BHxH15GRizXL0DX6iDO6xhlOkIf%2FJUkEX0NdRw7eELBOWURi5OebDc72iCboyfiCPuUE%2Fswp2UnPOck4ZQk4v7u5lQcmSwReCThYC5HyP3V9t9vdxDR5IRFNblZso9NEp5t1hZzpEBasKUc%2Fi8w7GscozdiWRgRFRGAac4S%2Fs1ygPcsztCmKiukLkV4phFyhLY5zgnASIci%2FIYlAgiHySla5IEisSVG4Sg8GTtQh%2BKYxAY%2BYcgFFPJF%2FaKJMKrOghA%2BtuTEJjcAaDuaGh%2F4W%2BHtMTJYDxj0yZ6ETeLPP%2Fsh2nmc3gfE4sfzReFz6rlicb5ITzuZsEk6dmreJ45V5IuLZngSWNxoOBs3YKzhZBPuULMH9%2FXBwSDYlmOcZ4W3cqWX4oVcv0yMxFtBEvqZpR4BnTYzAnjn%2BR9utlwvsMU6BvntkP8vSjnF%2BOJ0anv3Nkseq5LltfT4QJMseLHzBMvyDyFe2hIPxGD2gd9KkfSVcKz4cpsGlSsQIvwaSfX6OmhbOwnpNgQj5Spfo7gE9Tgznr9G4xpWLodMFAR1XOaZX%2BV3DC%2ByCjuoaHk5%2BEF9AkmZ%2BdaHbzgsVuPDCeEpWgm27%2BuRanu9aZmDPVa8Ob%2BRDxvKuPpnGxAxVqz54s9A9RmUs7kLwZpNa6m05yfdoajtfqnsXjobjzAKjujRaSHlYSj34T3Mf7SfCXwRLSyXQ%2Fh9fLeZyHpfAAQwV5WmM92%2BnauBZQeg5QEnoQN6CX6is%2BB1ornLca1dIUy0v2ANLkRmOa3P4x21pM9Xsy6BqaFFjLjXpp7rWjaXGrw1WG%2BTLaIfhvAh3fS37mcP0kegU9BtVOAtf79lRImoC0aekJ5rBmzxRzqihadet8sa%2FUd%2FdQ4%2F6Kl1r8VQZLvfnKIAX0RrK2IJsWC%2FjvtHRi%2BA2P0hssYjbT6MyX0JuaOJFXNiVJ2buIMC9u9xU49NS3IOMg0qTqFXYUcF71lVX8RK7G9ctNZpuO%2FioC3hvSpq6fha8Ugcpy0r1O%2BVBmfpPXntPnK3CY11vodgpvTHLVXOe6tYqeYtZrqiemGe2VgcW7C1VnVzcw19DLx73JAsAAA%3D%3D

Model Issues

This will help identify the issues or missing standards and best practices in your model. This is inspired from BPA rules in Tabular Editor. You can further extend with more rules.

Hope these scripts are useful. Share your thoughts in comment below.