1

PowerBI supports column descriptions (right click on a column and select properties), is there a way to set this column description from PowerQuery. It seems hard to believe this isn't possible, but I can't find it in the documentation for PowerQuery.

David Mulder
  • 26,123
  • 9
  • 51
  • 114

2 Answers2

0

I've been looking for this myself for a while. At the time being this does not seem to be possible. There's nothing in the docs, and not even in the ideas section in the forum or in the Preview Features as of September 2019:

enter image description here

I know this is not what you were hoping for, and I really do hope someone is able to provide a better answer.

vestland
  • 55,229
  • 37
  • 187
  • 305
0

Powerbi uses SSAS in the background. The column descriptions are stored in DMVs.MDSCHEMA_MEASURES, TMSCHEMA_COLUMNS & TMSCHEMA_MEASURES

You can set them in SSAS (if your using SSAS tabular as a source for your model) or view the PBI descriptions via DAX studio https://insightsquest.com/2017/12/14/query-power-bi-field-descriptions/ unfortunately I don't believe these can be set in PowerQuery

M O'Connell
  • 487
  • 5
  • 18