You can use Vertipaq Analyzer DAX scripts in DAX query view to get the details directly in Power BI Desktop DAX Query View or in Power BI service.
Detailed article with scripts are shared in my previous article – Vertipaq Analyzer inside Power BI Desktop DAX Query View – Hari BI Academy
This article gives a handy URL to open the Vertipaq analyzer scripts directly on Power BI service DAX query view. This is possible with the recent feature “Link Sharing a DAX Query” – DAX query view – Power BI | Microsoft Learn
it enables all DAX queries added as GZIP/Base64 encoded in URL itself and simply go and execute the queries.
One easy way to get the URL generated for your DAX query is “Semantic link labs”. Semantic link labs has a function to help you generate the links in a Fabric notebook at https://github.com/microsoft/semantic-link-labs/wiki/Code-Examples#generate-a-url-for-dax-query-view
Considerations
Need to enable “Data model settings” under workspace settings -> Power BI – > General.
If Write DAX queries view is disabled may be because of incremental refresh enabled semantic model.
Below are the URLs for Vertipaq Analyzer scripts.
Replace <WorkspaceID> and <SemanticModelID> with your workspace and model. You can get the IDs from your Power BI URL.
//Vertipaq Tables
https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIAIzN1mcC%2F8VW7W7TMBT9nTyFFW1oG6PpJvEHMSQ3cbugNhlOUlaqKvJaoxq6ZCSpSnktHoEXw3biJC1bN1UMpKq5vl8%2B99jXtmkCuMznSQpegUuSsjlJSQww%2BULjGZd00wQuuaXcOqRpzq7INwBjslhnNAUDmqdsmnFbQG4WFAwZXQEWAxtegw9Lmq6lRqTgsRlLYu551moLhZXEOZnmXDHP87vsjWmuVqvWgsVf6YzFrWlya7LYZLdzBSk1dRt1HRfpGg%2Fv0RzkcwpyOS%2BJZ3I0JSkPJguWr3VtCDGIJC6rVoML0MNeeNUZHema1nX6AcJC0hy367X8wMOwhwLY6SP%2F6PhUGLDTuwyki9ZH3VLSxtIncuzJaaE4l58iRDsT%2F8fg7TtgHBh6qR7bzgC5vuO5kQsHSAYaDWiGUPjh4FpOYYUYIzeQYEskY%2Bx99CPLC91gopIa2OEcJwuSc3azJ6Rwho7Xh4FAUWfSxU%2FyZZOc%2BOwHfTpPltcPB66Pery44N%2BQpkA%2BXm7oIzvynU9oq8xLRtO%2FUGZd23Zp50UxF8C4PDDAixdgXIZGbjjoIDzhpvbOIhXEvYo0T7gIZzM6AzdrgJlojIR%2F4%2Bmvn%2FHOjovp92V29rpt8gRRyJu8ooojzhOQ3OSEd7jotkxok89SXorjYM5dSTrln0zXTsyS640kz893uCffTZj%2Fm3NMFyVbDzOe0rLp5%2ByuSXcd%2B9xM4z2ZLhHu3702m%2B5VospbDKNgdIUEWqMDfceKbBjAR86dYt7HgduOJU5YiEf3wS%2FuygvgI44sUNi4jwuDEMO%2B47oIv%2FccV%2BaHtt1wqZzEAnlh0HDcabo%2F906DVl0Gp7VKdYjSHFc2tSr6lkFtSH1DvXEqNG8BI0hysgAFz2CsIEzASz4oZpCyipWDcgopNxNP9CrxHy%2BB6gYtlkO8cYwnX9PjhqLwaMIWDvW4vrPK%2FKoktadEF5O0TKxqrO6ARs6qrOrAAlseG8WrZmvYFVEPPB3GG6qJ2LI6GsJ%2BCAP%2B7NrciQWhRQ2dQ75WXQ8PYHFo2PyVYSN1fmwy0WidZpItz2JL1MtntFvt9qFRNZKHbYRBZwSaQcBGvvUb617RZNAKAAA%3D//Vertipaq Columns
https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIAAPO1mcC%2F%2B1XbW%2FiRhD%2BbH7FyrqekjYJkFZVVbWV%2FLLAtmCn6zU5aiHkA%2FdwC%2FYVjGj66zv7YnttCM1dvlaKEu%2FO7Lw88%2BzspNtF1qFY5zt0i0bxLl3HuzhDNP4jyVbw1el2kRdvE5BOk12RPsR%2FISuLN0%2F7ZIcmSbFLl3uQOfnmsM3QNE2OKM2Qa71Dvx6S3ZPY4Tbg8D7NM1Dt3%2FX4hpNnRbwsYGNdFB%2F333e7x%2BPxbpNmfyarNLtb5ttumnXT7bqMadftuHhAPNwxphZFC%2BXyRxTgMXaY44%2FDiRdcdQxjQMYMU%2F5lEG%2Fg3wXMp9YQM8sGRaV2fcPFkVwu2OwBz8GUaVsBcRauxSwT5ELJZPH7TSJAMPk6cskEewHxvYVnTfBc6KhgaiWLMUrskGFNyY2LGLGnj1IleCTMGYkoI%2B5QxCCiMl2bLxbkO%2FMGmSQrvv3GbAgeA0a5KAD4sw9NmTPjEjdZptt40xTZvj%2FmQjvPN0mcNYUQAhYn4yJhqUqjklIRipsfAAopqWOugHLTZQE1jqHsQfpPhZbDACuLzhYB%2Ba0JF86W%2BarMQMdDlQV7ju8Sbyhh6UMEIysYSf%2F3sJpa4xCLQnX4j6AFB5l7%2F0xi4CEUl5X8oGQ4YkLfGOOB%2BjIicWBBXBkXxCL%2ByCNGn%2F8GguO%2Fl5vDKkHFOkFLke%2BeS67RDz8h882n0Uswp8Y0DLB7imZlIgjtgBEG5BMB15GXuFaRB9iiCnOwg65MldCJIoAv%2F46xd6VJr%2FmFltmXXxIGk%2BZH77B9D13CbG3ctio2SpPdcxUbUj98sGciQq16LyzfS4rGb%2F3ojYnevkWROr7wwomNKW8IvTqjc4VpWzXLXGTOQTh5J907IaVgWaRTBqeVUXj5JEY0HEXl6jwfBMp9yAa6pyviAf6dC78vCyMP3L%2FgAFj9CjVObRLekgVLKtVKuC%2FiDwkPZEKk2ba5e25OfnJDt0ju6A5%2BT%2BH1ES5UaZVVCbjG55rOukZJZB6h2q%2BZqz64L4pZSD1hf8A91nQV1XHi3Ypvp8XTq2hbMVXrNDprT2mreFt2G9luLvQbveFcYrKppfQi9lL%2FMVg4fuixz6AvNIO9lGpu5zXIksL%2FgfKldl4CqzW%2FFpL3He36v%2Bqx%2F%2F9%2Bvf5%2B6cC2mahTDUx8XdNkoIK1XFfjRXNleBa4ssY8IR%2FeRPqzTzyZwvOSS6KLMkNR96ZalwOJ2ijvrVG9e837fNJf9Nni9F5oL64Hs7c2KCAyUE0nsMeW98tVVAnh2YbnzvE9ZhEvgGESZqzymdTIXbac%2Buk29WCi1rw3L7crN82%2BAJbL0KJGrHPgYP2E8UXbMq94B%2FNxD6bUjnHSCTQOtS9wvX5mUm8nrPUm%2FqVOtSl5SlUeeK%2BVqNKs4RGTnNxvQtAaoFXzOQOwePnRmae%2Fct%2BYqqPWqH3uP5GoWkrpF8i1hcAlU%2BJiNZLraWhvQw29rlRVHn2J%2Br2euLE%2BdTFF9gzVasjFgfMvcX%2BpQ4IOAAA%3D//Vertipaq Relationships
https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIAF3O1mcC%2F90X246aQPQZvmKCfdDUSnf71qQPiMMurcAWRrctMYbqtEyLsAWsa7%2B%2BcxG5iK6bZtNkE6Mz534%2Fo6oCbZ2HSQpegesgJWGQBjFwgx84XtKTrKrADlaYYqc4zclN8AtocRBtM5wCC%2BcpWWQU5%2BIoyEkSZyG5A1OCN4DEYKR9Ah%2FXON1yCJNERWSUijJcDF4zgJ7EebDIKSDM87vsrapuNptBROKfeEniwSJZqSRWySosLEtVeQQN04ayNNVcMK8q9sgfDN4BD46hjnRnPLFsrytLkmGOEXTZSTJtwxl4yHG1K4i0ISUUZPDKgjbyur0%2BoxpDA3FyyedEc3M04wjpkn33qBLFfaHQM6dXUPA1wjxMCrv7I5NK80zHntuaBTmrMsnwEjALBcnEg6O5Z37ZYWvxM0echvt3QXVRd0fcHKXLEU2rLpghBcPlGQxU6ktQcLkQTVybgb3J0EMmmiAonLdMIeUwDBJVQyXsL%2FxXxE5SesruoPBgyezDTTPSZKUn0XoV60FK0xtEJN8%2BNmGPydF1JUdMORDan1mAD9yrRFcUm%2BvcenPdmdhoRjvtTZkRlPy3fKDkGWejdO78XNRGQEsSeORdONYQHSzetXmzi3zr7DAc19JEPvzCDaXT6TT6QQyuHY%2FPQByy42jrmargsp%2BrKjq1HNc1oKQm%2F6AGqtKL2mw3X0%2BTLAMGiXK6h4Y4DH4TusKYRVyQd2si%2FVoI4qSCksTfC9pdLfWB4sRiJkuX9DJM8lDcFC9Z4TykLABHGW5OkkZeqwp5XEr8EU1WEG8f0NTuZBclvSd3kqXmhIs0Of%2FoYH0tiDI5VvXVQdNWuLV65ahyF7PTrDrxHqHqoH4rhXtaza41jqop7r1z%2BuxId1W49naYhpjS3nCs2R%2B6Pry%2Fi8iC5Nw8MbF8M%2F6G0xQvOUyAamT17PA2PNOPk%2F18fEY8oQ8ynGrjiYboc%2FHAAVujm0Abs8Xl0CXgvndMm2s%2BijiBKVCmbdfAp1gkqfg9SfQAVqptjn4F3vre2uN7JWnbO0Dekx28seWGgLKD5RqiaLbquiyM2u%2FKnfK2vVR2V72xD5dTg7IsqHq7VuiqHdxcRjWqpqz9ivGbe6AQU7I2cW3zfE0HOpM0E2zH95oQUfkHUfyhEAgruAff2jaTf%2BRpWLK1zHq%2F9QUjBpzjjqALhp%2BB38jVrA%2F8ZlZmfwGjbkkPYA4AAA%3D%3D//Vertipaq Partitions
https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIALTO1mcC%2F42RTY%2FaMBCGz8mvsPZUJBa310o9uOCyWSVOmhhUqUKVS7zgLdjUMY349%2FVHEtjCtj1l%2FLwzk5l5IQToaLZKg3vwwLTYMs0kKNkzl7WNYggBYXtu1SXXRhTsJ0CS7U4N1yDjRot1Y7XCVhqhJPgleAuEBDP0BXw%2Bcn0CS0tcF1veuIx78G7y1oGpkoatjQVbYw7Newjbtp3shPzBayEna7WHQkKx3%2FZTaRjjJUoXiOI4WqISfDswO5L%2F7wdQ4RRP6TRPFxmp3sRRlJBP%2BaRAJU1okls0Glt4R9n3HU9md2PwtQtXnhd9q8oozTZdyjUN2e4kTnffQPyyDvlgxp%2BE9IVBrQwzvsAHgWWq9sh9AymZ3HCboY3j59eFimU9aDa%2BUOb2Qsed8%2BE0ZFywVRyN4u5sxi3%2B6sko%2BpjiG%2Bfqd%2FfoxQFC6xLTRUlsxlXbiCAroTQhBJePeUI8fIVGZ1fHAfipKjzPMKEZKiqal2juJvTyKGSFpeIBvBxzeKyCOPh6ZeSfTnbwhoE3HPyHhX%2Fx8D9N7FJV23iZr5Wup%2Boo%2B%2F4V3%2By5NB75aS%2FefbEvag5cd%2BK5U1MM0HoajX4DB5QXrBwEAAA%3D//Vertipaq Model Size
https://app.powerbi.com/groups/<WorkspaceID>/modeling/<SemanticModelID>/daxQueryView?query=H4sIAPzO1mcC%2F8VW%2FW6bMBD%2FG57CQlXVdl1Iq%2B2faZ3kBCdhCtAZyNpFEXLBFd4IdIQozV5rj7AXm813%2BpFW2apKUTjfl%2B9%2BPp9PVQFcZmGSgrdgRFIWkpTEAJPvNA44JasqMMmccumEphk7Jz8BjEm0XtAUGDRLmb%2FgMns5n5N0DSaMrgCLgQYvwJclLTnCCbdesCTmuiedrmD0kzgjfsYZYZbdLD6o6mq16kQs%2FkEDFnf8ZK6yWGXzsAoqVWUNDXQTyRI3H9IMZCEFGbmKKCBxkK98knJjErFsLUsTiIHnCHm%2FYYMzMMSWe967PJAlaaCPHYQFJenmwOrYjoXhEDmwN0b2weGxEGB9OHJyFWmMBiUlTXMdT9dmxwXjNP8UJtKJ%2BOdRols%2FWga0iC2JlvN4ISSH4OMnoOwpcmkw1XQDmbZumZ4JDZS7VFpBK4Jhu8ZFvnnfxRiZTp5GGeMUW19tr2%2B5pjOrnCpYn7AkSnySceCf4UKf6NYYOiKKxpMsfi28A5IRsGC%2FKLjmNUOJHxZHUMKtcbEtpM%2BGuW%2BNXcO00ZAj4Lw25lX4T6Pl2kjzbP0behClkNGUpH64LqBKru8jNeIq%2FwGpBp676JwWWZ8BZbSngP19MC1NPdM1egjPuKi7FY0qxN3QOOIkDAIagKs1wExczYR%2FY%2F%2FP73jrnY%2Fp7XJx8r6rcgeeyxtNDRWPOEtAcpUR3mMEzhW6gl6KllQBzyg%2F9CO1xHrDycvj7e6IdzvM18Yc06hE63HEUxrlvWURsps23I3tSyONd0S6jPBfrnnAfJG7ePUeveMa83cCotq9WHrO5TkSOSk9aOt9T4MOfKKNFfs%2BnZ6m90W%2Fh%2FjyTpLN28n3tRGPzKli4zomdFwMx7ppIvzZ0s3cP9S0lkqtJI7Rcp2W4lbRw763CqT61TluWNU9qjiHtaw6FfmOoCpbeYO90Tvaz43iJBmJQIEzmFYhzMAbvih2yOnKNl%2BUW%2BR02%2FFMrh3fm1jq97w4DjGNKc8eGqYtRqHRDlsoNOvmCSz9VylVNVXWeyktc6xfipbPOq3WHNJMIdONwWQm6k1GEzh2ocNnO16vBsS8GMX5FmDkXvKLxJuQ0cudaHxa0XKdNtlUe9tW2kxzY2jonr5rsC9X4gr8BYtGJ3cYCwAAHope this is useful. Please share your thoughts.
Leave a Reply