Forum Discussion

Vivek_ta's avatar
Vivek_ta
Regular Visitor
1 year ago
Solved

Column Description

Can i get the source level column descriptions to the Power BI

  • Hi Vivek_ta ,

    Thanks for reaching out to the Microsoft fabric community forum.

    Idrissshatila 

    Thanks for your prompt response

    Vivek_ta 

    To better understand and provide the right guidance, could you clarify a few things? Specifically, what data source are you working with (SQL Server, Synapse, Excel, etc.), and are the column descriptions already defined somewhere like extended properties or a metadata table? Also, how do you plan to use these descriptions in Power BI do you want them as tooltips, a reference table, or something else? Lastly, do you need the descriptions to update automatically with the data, or is a static import fine? Any additional detail would really help us point you in the right direction.

     

    Looking forward to your response.

    Best regards,
    LakshmiNarayana.

     

7 Replies

  • Hello Vivek_ta ,

     

    column and measure description are entered manually, or you can make it through tmdl view as below screenshot

     

     

  • Vivek_ta's avatar
    Vivek_ta
    Regular Visitor

    Idrissshatila 
    Thanks for the reply
    So apart from manually entering details there is no option to bring the Source Descriptions to Power BI 

    • Idrissshatila's avatar
      Idrissshatila
      Super User

      Hello Vivek_ta ,

       

      yes they should be added into the model, you may see if copilot in vs code would help if he has access to both sources.

  • v-lgarikapat's avatar
    v-lgarikapat
    Community Support

    Hi Vivek_ta ,

    Thanks for reaching out to the Microsoft fabric community forum.

    Idrissshatila 

    Thanks for your prompt response

    Vivek_ta 

    To better understand and provide the right guidance, could you clarify a few things? Specifically, what data source are you working with (SQL Server, Synapse, Excel, etc.), and are the column descriptions already defined somewhere like extended properties or a metadata table? Also, how do you plan to use these descriptions in Power BI do you want them as tooltips, a reference table, or something else? Lastly, do you need the descriptions to update automatically with the data, or is a static import fine? Any additional detail would really help us point you in the right direction.

     

    Looking forward to your response.

    Best regards,
    LakshmiNarayana.

     

    • v-lgarikapat's avatar
      v-lgarikapat
      Community Support

      Hi Vivek_ta ,

      I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. Should you have any questions or require further clarification, please don't hesitate to reach out.

       

      Best Regards,

      Lakshmi Narayana

      • v-lgarikapat's avatar
        v-lgarikapat
        Community Support

        Hi Vivek_ta ,

        If your issue has been resolved, please consider marking the most helpful reply  of Idrissshatila as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.

        If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.

        Looking forward to your response.

        Best Regards,

        Lakshmi