Forum Discussion
Q&A with multiple datasets on the same dashboard
I think you don't have this option..This was and option (still is ) to choose what data model to use in Power BI for O365 (V1) , with some others great options to monitor questions not found, usage, custom phrasing , in the Power BI admin center.
Until ( I hope it will transfered to V2 ) then, when you pin a graph in dashboard it automatically reads the data model for Q&A
Unfortunaly no. Only the one we configure gateways & stuff, which doesn't have any of the features of PowerBI V1 we are discussing..
Community ChampionI don't see a way to do this, they sort of need the way that Power BI for O365 allows you to select fields from all of your data sources, but it looks like the fields list is getting filtered down to just one data source from my experiments.
Right - it does filter it to the only source that gets selected. Is there a work around (other than creating one dashboard for each data set to get the Q&A answered for that set).
Because Q&A is such a great service , only if you can toggle or specify where to get the results from , it will be just incredible
Please let me know if anyone has found any work arounds
Sheikh
- ajanson
Kudo Collector
sayub,
what kind of datasets have you got there? Both of them are Power Pivot models?
Make sure that your datasets meet all conditions described here: https://support.powerbi.com/knowledgebase/articles/474690-make-your-data-work-well-with-q-a-in-power-bi
Hey ajanson,
actually one source is a direct power pivot model, the other dataset is from a published .pbix file from power Desktop.
But since the dataset was similar thats why it was hard to see but it seems that the Q&A is performing its default behavior which is "selecting the most appropiate dataset for your Q&A question". Now just to clear out my question further, what i wanetd to know was , is there a way to select a dataset that i want to use regardless of if Q&A engine thinks of it the better source or not. So since we have two dataset, and when i type my question in Q&A it goes to source 1 automatically but i want it to go to the second dataset. Not sure if its possible to toggle between datasets manually.
I hope it further clears my quesiton now.
Sheikh
