Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jshutters
Resolver I
Resolver I

Data 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.

 

CategorySubjectDefinition
ProteinSalmonPink fish
Recommendation: eat weekly
Related meals: Baked salmon
 Chicken NuggetsProcessed chicken that is fried
Recommendations: eat sparingly
Related meals: serve with mayo and tater tots
GrainTater TotsGrated potatoes formed into cyclinders
Recommendation: eat sparingly
Related meals: serve with chicken nuggets
 PastaMade from semolina flour
Recommendation: eat weekly
Related meals: spagetti and meatballs
 PopcornFluffy snack food from corn
Recommendation: great snack food
Related meals: none
 BreadStaple food made from flour
Recommendation: eat daily
Related meals: sandwich
FruitAppleFruit from an apple tree
Recommendation: eat daily to keep the doctor away
Related meals: apple pancakes
VegetableBroccoliThick stalks with green florets
Recommendation: eat weekly
Related meals: Beef with broccoli
1 ACCEPTED SOLUTION
v-yuaj-msft
Community Support
Community Support

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.

v-yuaj-msft_1-1618800770328.png

v-yuaj-msft_2-1618800831108.png

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

v-yuaj-msft_3-1618801097233.png

v-yuaj-msft_0-1618800140657.png

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.

 

View solution in original post

2 REPLIES 2
v-yuaj-msft
Community Support
Community Support

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

v-yuaj-msft
Community Support
Community Support

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.

v-yuaj-msft_1-1618800770328.png

v-yuaj-msft_2-1618800831108.png

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

v-yuaj-msft_3-1618801097233.png

v-yuaj-msft_0-1618800140657.png

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.

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.