Forum Discussion

sbroaden's avatar
sbroaden
Icon for Helper I rankHelper I
8 years ago

Master slicer to filter 2 models

I have 2 complex PowerBI models that can be joined by some common fields but for the most part, they are very different in nature which is why we have split them out.  Below are my examples.  I am wo...
Need Help
sbroaden's avatar
sbroaden
Icon for Helper I rankHelper I
8 years ago

My problem is that the 2 models were created awhile ago before the need to use them together arose.  If i combine them together, the model will be too large.  Each one has over 100 measures in each and I really don't want to combine them.  I want to find a way to use them separately but join a common field only WHEN NEEDED. 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi sbroaden,

 

Do you mean the 2 models are in two datasets (two different pbix files)?

 

Best Regards,

Dale

  • sbroaden's avatar
    sbroaden
    Icon for Helper I rankHelper I
    8 years ago
    Yes. 2 different pbix files with lots of measures in both.
    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi sbroaden,

       

      This isn't supported by now. The workaround could be bringing the two datasets into one single file. Or, you can only import the needed data source into each file respectively. You can vote on an idea here or create a new one.

       

      Best Regards,

      Dale