Forum Discussion
Resolver IData Modeling for Q&A visual for an encyclopedia-like experience
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 |
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.
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.
2 Replies
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.
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.
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