Forum Discussion
Synonyms Audit
Hi there,
Is there a quicker process of auditing the synonyms? I currently go into table view of the pbix file and then click on each table to manually capture the synoyms data.
Any help would be greatly appreciated.
Many Thanks,
Ajay
Hi AjaySonoo ,
You can check the following link, hope it will help you:
https://data-marc.com/2020/02/10/synonyms-the-secret-behind-power-bi-qa-and-natural-language-query/
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-tooling-advanced
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi AjaySonoo ,
You can check the following link, hope it will help you:
https://data-marc.com/2020/02/10/synonyms-the-secret-behind-power-bi-qa-and-natural-language-query/
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-tooling-advanced
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI AjaySonoo ,
Not sure on what you are talking about here. Can you add more details please:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks,
Pragati
Pragati11 I've added the images to illustrate the location from where i'm manually capturing the synonyms:
1. Click on Model view
2. Higlight the table
3. Within Properties panel, the synonyms can be seen.
Is there a mechanism that can extract this detail without having to carry out this process manually?
Thanks.
Just jumping on this thread. Whilst it appears it is not possible to simply export a list of synonyms by field from a PBI data model, I'm wondering if it's possible to view all field synoymns by deconstructing the PBIX (changing the PBIX extension to ZIP). A cursory glance suggests this information would be stored in the compressed DataModel file but perhaps someone has successfully attempted this?
