evaluating field usage in power query / power bi
RIP Field Trip…a great app it was. there are other apps now that do the same thing, and free ones to boot. I’m sure they are great but my new job has some hoops to jump through to install them so i tested out the idea i had years ago to do this using power bee eye.
The M language used in power query makes it remarkably easy to do this. It has a Table.Profile function, which takes a table as an input, and returns the usage, like magic.
You can use the salesforce integration to pull an object, and add one line of code in advanced editor, and you have it.
If you want to filter by record type, etc, you can do that via the power query UI, prior to adding the line of code. I dont think its possible to do this in power bi itself, but gonna try when i have the time.
Note that if you run this on your desktop and have an object with a lot of fields and a lot of records, your machine may get...


