cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

How to ask questions in Power BI Q&A that show results from multiple data sets

One question around Q&A in Power BI around ‘how to ask Q&A questions in Power BI that show results from multiple data sets’.

 

I have two ‘pushStreaming’ data sets in Power BI e.g. one is for Orders and another is of Payments. I have a dashboard with Q&A enabled, which has table and pie charts from reports built from the two respective data sets. That means that I can ask questions in natural language about Orders in Orders data set or for Payments in Payments data set on that dashboard. So, when I ask questions, it will either answer that through the Orders data set OR through the Payments data set.

 

Please note that my payment data set has a correlation ID as well, that’s called OrderID so that I can potentially correlate the information across the two data sets and show all orders with a specific payment status.

 

However I am not able to let Power BI Q&A work in a way that it combines the data from both the data sets, as it just tries to stick to either of the two data sets as the source for it’s query response.

 

The section “Combine results from more than one data set” at https://powerbi.microsoft.com/en-us/documentation/powerbi-service-q-and-a-tips/#combine-results-from... suggests that it’s possible to combine the results from two data sets in Q&A.

 

Any help / pointers on how to make Q&A to combine the results from two data sets would be great.

2 REPLIES 2
Microsoft
Microsoft

Hi @zeeshanqadir,

 

1. What are your two datasets exactly? Push dataset and Streaming dataset are two different types of real-time dataset. If they are both Push dataset, Q&A is supported. Because Streaming doesn't have a underlying dataset, Q&A isn't supported.

2. Can you see them from prompts of Q&A?

The part in blue rectangle is guidance. The parts in red rectangle are datasets.

How to ask questions in Power BI Q&A that show results from multiple data sets.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

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

Hi @v-jiascu-msft

 

Thanks for the response. 

 

The two datasets i.e. Orders & Payments are 'PushStreaming' datasets and Q&A is available on those. For 'PushStreaming' datasets, the data is stored in Power BI. These datasets are created through Power BI REST API using the Create Dataset API. The snippet of the JSON posted on that CreateDataset API to create these datasets is as below: 

 PushStreaming Dataset in PowerBI.png

 

The data is inserted as a stream into these datasets through the Power BI REST API too as I can see the data in real time reflected and showing up in the reports and dashboards as soon as the data is inserted through REST API.

 

Also the Q&A is available on both the data sets too, as shown in the below picture: 

 

Q&A Showing Both Data Sets to Ask Questions About.png

When I ask questions in natural language through Q&A about the data relevant from any one of the data sets, I do get the relevant results shown up, however when I ask questions that require data from both the datasets i.e. Orders & Payments dataset, the Q&A is stikcing that to one of the two datasets and isn't able to get the data from both the datasets together. 

 

Any tips on how to ask questins in Power BI Q&A so that it shows results from multiple datasets. 

 

 

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors