Forum Discussion
Can I dyanmically set Column Description in Power Query
Hi rpiboy_1 ,
Thanks for the feedback. You are correct. Using tooltips to describe metadata can be a limitation, and defining metadata through scripting or manual effort is a rather complex task. Unfortunately, Power Query does not have an intrinsic method of defining metadata descriptions directly.
Your idea to let Power BI inherit metadata from Power Query or allow dynamic descriptions is good. Since this is not currently supported, I suggest submitting a feature request on the Power BI Ideas Forum. This will bring attention to the need for this enhancement.
You can submit your idea here: Microsoft Fabric Ideas.
If my response solved your query, please mark it as the Accepted solution to help others find it easily. And if my answer was helpful, I'd really appreciate a 'Kudos'.
Update:
This is not possible. You can have a description i.e. as a separate column.
I.E. what? Where would I put a seperate column to describe the columns in the semantic model for the benifit of users building reports and performing analysis? The hope/goal was to update the information that is available for those users, and to avoid having to manually populate the data given the quantity of Columns involved and the fact that I already have the data structured to begin with.
You can import your Column Table into PowerBI as a separate table. So everyone can see the description.
That is terrible UX, not going to make user have to reference another table just to know/confirm what the data column represents. I'll deal with manual population of description, its just not ideal.
