Forum Discussion

olegkazanskyi's avatar
olegkazanskyi
Helper II
4 years ago
Solved

DMV Query to pull column synonyms from Power BI Service

Hello,

 

I can retrieve information about the available columns using these DMV Queries:

select * from $System.TMSCHEMA_COLUMNS
select * from $System.DBSCHEMA_COLUMNS

 

But synonyms used for AI Q&A are not available there.

Does anyone know how to pull these?

  • Hi, olegkazanskyi 

     

    We recommend you to use Q&A to extract synonyms in Desktop, this feature is not available in Service for now.

     

    Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    This is the relevant document, hope to help you:

    https://docs.microsoft.com/power-bi/natural-language/q-and-a-tooling-teach-q-and-a 

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

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

    Hi, olegkazanskyi 

     

    We recommend you to use Q&A to extract synonyms in Desktop, this feature is not available in Service for now.

     

    Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at https://ideas.powerbi.com/forums and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    This is the relevant document, hope to help you:

    https://docs.microsoft.com/power-bi/natural-language/q-and-a-tooling-teach-q-and-a 

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.