View My Drafts
As of 07/21/2020 (Also on LinkedIn)
Every organization may have 100 different ways that the same subject is referred to depending on the referring department, team, and individual. That is what makes the Q&A feature within Power BI so much more powerful with July's enhancements.
First, when you add the Q&A to your Power BI canvas, it already suggests some topics to get the user started. The icon in the upper right corner of the Q&A visual that appears to resemble a gear will allow you to configure many features of the Q&A, this article will just focus on the Field Synonyms.
The Getting Started landing page gives you four main options:
The Field Synonyms list every entity that is within your data model which allows you to toggle rather the table or the attribute of a table should be accessible to the end user's Q&A. This is an amazing feature as it now allows the report developer to mask any fields or tables that were created for modeling, design, and such, but were not meant for the end user to see in the Q&A. However, if there are many attributes in your table, you would have to turn them off one-by-one. It would be nice to turn them all off by default and then add back in the ones that are needed, but hey maybe that will be a future enhancement.
Each attribute of the table will have a Name of course, Terms that are approved synonyms, Suggested Terms, and the toggle to include or not.
Clicking the plus sign on a term from the Suggested Terms section will remove the term and apply it under the Terms section.
To remove the term from the Terms section, the "X" will remove it. However, note that the term once removed from the Terms section is not added back to the Suggested Terms section.
The Terms section allows you to add any custom term by clicking the Add button. This may be the terms that you accidentally removed or organizational terms that are significant to the department, team, or to certain end users.
Keep in mind that from the Model view, clicking on either a Table or an Attribute exposes the Synonyms section under the Properties as well. For providing synonyms here, it is a little more robust since both Field Synonyms and Table Synonyms can be applied. This has been available to Power BI for some time.
Any changes that you apply here will then also be reflected in the Q&A settings, except for the Table synonym although it will still exist. For example,
If we add "employee" under the Person attribute
then we will see the added synonym employee as a term under the Terms section.
So, the benefits of the Q&A Field Synonyms update for me are:
To bulk load synonyms for an attribute, pasted them as comma separated terms in the Model View's synonyms section under the properties.