Forum Discussion
Q&A with multiple datasets on the same dashboard
Hi,
I have a question:
I am working with two data sets which are very similar just that one has a little more information than the other. I have these two datasets in power BI as shown in the picture below. I have reports on both datasets but i want to build only one dashboard which has visulization from both, i can achieve that by pinning the visulizations to the dashboard. But since i have one dashboard and two datasets when i use the "Q&A" service it is defaulting to only one source (as shown below, Source: Power Pivot test) . Is it possible to toggle and choose what source we want to get an answer from? in my case if i want to use the skill profile dashbaord source?
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..
8 Replies
I 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
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
