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

     

     

     

dufoq3's avatar
dufoq3
Community Champion
1 year ago

You can import your Column Table into PowerBI as a separate table. So everyone can see the description.

rpiboy_1's avatar
rpiboy_1
Helper V
1 year ago

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.