Forum Discussion

rpiboy_1's avatar
rpiboy_1
Helper V
1 year ago
Solved

Can I dyanmically set Column Description in Power Query

I have a data model where the columns of the final query being loaded into Power BI are dynamically renamed and typed from another query. This is due to how the REST API that is being queried functio...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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'.

     

     

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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'.

 

 

 

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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.