How do I look at query data for datasets in power BI?

[trevb]

If I have created a dataset in PowerBI Desktop then I can see all the calculated columns etc.

I have a prebuilt dataset that I would like to understand the content of the calculated columns.  How can I do this?  I can see the columns are calculated from the little Icon but I cannot dig into this.  Anybody got any ideas?

Trev

[kcantor · Accepted solution]

If you are referring to a .pbxi file simply open it in the desktop version and navigate to the table containing the measures in the data model (signified by the table looking icon to the left of the workspace in red). Make sure you have the correct table then scroll down the fields until you see the measure (circled in blue on my image). Click on it and it will show you the DAX in the measure field where it can be edited or copied to create a new, similar measure (in Green).

Hope this helps.

EDIT: Of course this is a file that was "pre-built" by me or could have been "pre-built" by a coworker. Content packs and such are different.

[Greg_Deckler]

When you say prebuilt data set, are you referring to using a Content Pack?