Forum Discussion

dnewton's avatar
dnewton
Helper II
7 years ago
Solved

Merge two datasets (.pibx files?)

I have two .pibx files connected to different SQL sources each with their own calculated columns and measures. I have been asked to create a report pulling together data from both datasets but on a single report.

The only way I can think to do this is to merge the existing .pibx files. I know I can add multiple SQL data sources easily but can I merge the existing .pobx datasets so that I don’t have to recreate my calculated columns and measures from scratch?
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    dnewton,

     

    In power bi, one dataset can contains multiple data source, however, multiple datasets can't be combined as one dataset. So I'm afraid this couldn't be achieved, as a workaround, you may add the extra data source to one dataset and recreate visuals in another page.

     

    Community Support Team _ Jimmy Tao

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

3 Replies

  • itsmebvk's avatar
    itsmebvk
    Continued Contributor
    7 years ago

    dnewton do you have any issues in using Workspace within the Service? the only draw back i can see is you can not do everything as you do in Desktop .

     

    Alternatively I would use advanced editor to copy paste the queries over and recreate few columns.

    • dnewton's avatar
      dnewton
      Helper II
      7 years ago

      I have both datasets in the same workspace - but the problem remains that I can not create a single report showing visuals and measures from the two datasets, they must be seporate.

       

      Unless using a dashboard but then that means additional cost through licences (as opposed to a share report link).

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        7 years ago

        dnewton,

         

        In power bi, one dataset can contains multiple data source, however, multiple datasets can't be combined as one dataset. So I'm afraid this couldn't be achieved, as a workaround, you may add the extra data source to one dataset and recreate visuals in another page.

         

        Community Support Team _ Jimmy Tao

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