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'.
Hi rpiboy_1 ,
We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.
Your feedback is valuable to us, and we look forward to hearing from you soon.
Thank You.
My feedback is that neither solution is particularly ideal. Using tooltips in this way prevents a report author from then employing tool-tips for their intended purpose while authoring a report. The second option sounds like it is not as simply as doing something in a dataflow, rather a script/programmatic solution would likely be required. I think it would simply be more useful if the Power BI description were exposed in the Power Query model, or if Power BI description could read meta data from the Power Query model. A last resort option would be that description could be set via DAX, but in reality that description should be controlled by the person managing the data model and the transformations, not neccessarily the person who might be building a report.
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'.
Hi rpiboy_1 ,
we wanted to check in as we haven't heard back from you. Did our solution work for you? If you need any more help, please don't hesitate to ask. Your feedback is very important to us. We hope to hear from you soon.
Thank You.
