Can we use multiple datasets in a single report in fabric

[sudhav]

Hi Team, 

I would like to create a report in fabric.

I have to create a new Dataset3 which is  taking 2 tables from Dataset1 and 2 tables from Dataset2 and need to give relationship and create reports.(it is possible in Desktop vesrion,but i need it in fabric)

 those two datasets are at different worspaces and i need to create a report in third workspace by creating new dataset

is itpossible? if yes, can you please guide me on this.

TIA

[Anonymous · Accepted solution]

Hi @sudhav ,

Yes, it's possible.

In Power BI, dataset creators can control who has access to their data by using the Build permission. Dataset creators can also certify or promote datasets so others can discover them. That way, report authors know which datasets are high quality and official, and they can use those datasets wherever they author in Power BI.  About more details, refer to

Introduction to datasets across workspaces - Power BI | Microsoft Learn

Learn how you can create reports in your own workspaces based on datasets in other workspaces. Refer to

Create reports based on datasets from different workspaces - Power BI | Microsoft Learn

(it is possible in Desktop vesrion,but i need it in fabric)

For this point, you can create a report(data source are dataset1 and dataset2) in Power BI Desktop and publish it to Fabric (Power BI Service).

Best Regards,

Stephen Tao

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

[amitchandak]

@sudhav , You can create a shortcut and view data on one workspace into another one and there you can add the tables in your model

[sudhav]

Thank you Amit for the response, hare my question is need to create one new dataset by using two existed datasets, is it possible? please let me know.