Merge two datasets (.pibx files?)

[dnewton]

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?

[itsmebvk]

@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]

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 · Accepted solution]

@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.