Query Model Expressions, Descriptions for Tables, Columns, Measures in the Power BI Service

[@bi-ome]

Microsoft released a new way to query and display this locally a week after I published this video! Please see the updated video linked below for more info. I am leaving this one up for now because there is a bug with the new feature that makes me hesitate to recommend it yet, but once that's fixed I'll be delisting this. 🙂 kzbin.info/www/bejne/jIGognWPrceCa68

[@pbiqueryous]

Wonderful! Immense knowledge, thanks for the demonstration, Christine! 🧙🏼🔥

[@cristianprifti]

Really nice solution! Did not knew this method as well and now with the Info.View functions we get even more options. The sound is good :)

[@bi-ome]

Yeah! Be careful with info.measures - going to try to fit in a video on that later today, there's a bug with it that is pretty gnarly. It should get fixed soon but FYI

[@cristianprifti]

@@bi-ome was planning to try them out, but now I will be patient and wait for the video 😁 So far I had some issues on a quick test with the .Measures one.

[@bi-ome]

@@cristianprifti Just finished it! kzbin.info/www/bejne/jIGognWPrceCa68

[@zzota]

Mind blown. Thanks Christine.

[@emilmubarakshin49]

wonderful thank you for sharing this is so cool.

[@bi-ome]

There's another new feature related to this with the INFO() measures that just came out today too! Now I need to do an update already, lol

[@angebeda6739]

How, I was currently looking for a way to document my models. Thank you so much !!

[@noahpayton180]

This is really cool.

[@jenskarlsson516]

Is there a way to find same kind of metadata from the reports? For example you want to build a metadata report about not just models but also all the measures created locally in all the reports, what tables, columns, measure are used in what reports etc?

[@bi-ome]

That's a good question - I would think this should be in the Power BI admin API if nothing else, since that has virtually everything. I don't have it up and running on my tenant to test though.

[@mirrrvelll5164]

Wow! It's simply amazing. I just tried it on one of my reports. This gives another perspective on data, story, and end-user view. Just one question, this is actually export of "everything" let's say so, and this is not for vice-versa way where you can edit in PQ let's say, and to be reflected afterwards within Report`? like something similar to what Tabular Editor does? (just an idea) =) Thanks anyways for this great Video!

[@bi-ome]

Thanks! I'm not sure what you mean edit in Power Query? You can add custom columns and replace values and that sort of thing, but you can't push changes back to the model from there. You can make changes locally to column/measure descriptions in desktop to the model and republish, though, then when you refresh those would be reflected in the report. You could also use Tabular Editor to push stuff to your descriptions etc, then publish that, and then pull it with PQ. That's why I mentioned Brian Julius' post, because he uses AI to write the descriptions for measures based on the expressions and pushes it into the model with TE, so you could hypothetically then query it like you would any other metadata for the model and it'd be mostly automated.