Data Modeling for Q&A visual for an encyclopedia-like experience

[jshutters]

How would you model this data to allow for an encyclopedia-like experience using the Q&A visual?  For now, the plan is to store the data in Excel, import into Power BI, and refresh it on an as-needed basis.

Desired user experience includes:

• If user types... What is Salmon, then Q&A returns the definition.
• If user types… Show me Proteins, then Q&A results would list those 2 items (i.e. Salmon, Chicken Nuggets)
• If user types… What to eat weekly, then Q&A results would list Salmon, Pasta, Broccoli
• If user types… Honeycrisp, then Q&A results would show Apple's definition, because Honeycrisp needs to be setup as a keyword/synonym for apple.

For the purpose of this forum, I've swapped out my business terms with silly examples of foods, so this challenge is easy to understand.

To be clear, there are no other data sources involved in this dataset. Meaning, this entire report is dedicated to act like an encyclopia for business terminology, definitions, related info.

Category	Subject	Definition
Protein	Salmon	Pink fish Recommendation: eat weekly Related meals: Baked salmon
	Chicken Nuggets	Processed chicken that is fried Recommendations: eat sparingly Related meals: serve with mayo and tater tots
Grain	Tater Tots	Grated potatoes formed into cyclinders Recommendation: eat sparingly Related meals: serve with chicken nuggets
	Pasta	Made from semolina flour Recommendation: eat weekly Related meals: spagetti and meatballs
	Popcorn	Fluffy snack food from corn Recommendation: great snack food Related meals: none
	Bread	Staple food made from flour Recommendation: eat daily Related meals: sandwich
Fruit	Apple	Fruit from an apple tree Recommendation: eat daily to keep the doctor away Related meals: apple pancakes
Vegetable	Broccoli	Thick stalks with green florets Recommendation: eat weekly Related meals: Beef with broccoli

[Anonymous]

Hi @jshutters ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna

[Anonymous · Accepted solution]

Hi @jshutters ,

Based on your descriptions, I think you could modify your question a little. If it can understand your question, the right outcome will appear. I did a test. Please check the results as follows.

You can also add definitions to make Q&A work better with your data model with "Teach Q&A" in Q&A Setup.

For more learning, please refer to the following links.

Q&A updates 

Power BI Desktop Update - October 2019 - YouTube   (from 5:00)

Hope that's what you were looking for.

Best Regards,

Yuna

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