Forum Discussion
1 PowerBI Report with data from 2 datasets
Hello community,
For PowerBI we use data from 2 applications (one CRM and one financial). The data comes together in the same datalake, but for PowerBI a separate dataset and thus model was developed for each application.
Now I need to make a management report that would draw on data from both applications and thus from 2 datasets.
I tried to combine the two datasets into one with some Excel imported files to bridge them, but have run into issues with the same measures giving different results. I am guessing the cause lies in a difference in relationships / both datasets having a both-way cross filter direction. The datasets were never meant to be in the same PBIX.
As alternative.. Is it possible to make 1 report that uses data from 2 datasets? Or is the only way a (newly designed) composite model dataset that contains tables from both applications?
Thanks in advance.
Hi Anonymous
You can create a report with two datasets in Desktop . When you connect to the first dataset , your connection mode is Live Connection , then you can convert the connection mode to Direct Query . Then you can connect to the second dataset .
Notice : If you want to convert LC mode to DQ mode , you need turn on Direct Query for PBI datasets and AS in Preview features . You can update your Desktop to the latest version and then test .
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
You can create a report with two datasets in Desktop . When you connect to the first dataset , your connection mode is Live Connection , then you can convert the connection mode to Direct Query . Then you can connect to the second dataset .
Notice : If you want to convert LC mode to DQ mode , you need turn on Direct Query for PBI datasets and AS in Preview features . You can update your Desktop to the latest version and then test .
Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.