Combining two Power Bi reports into one

[Anonymous]

Hi All,

My colleague and I are working on different Power BI reports based on excel data. The excel data from myside is fairly less so its easy for him to import my data in his Power BI report. For me its very difficult as he has multiple data sources. He cannot share that data sources (excel sheets) for organizational reasons but can share some parts of data in power BI (lets assume there is no way to get his excel data). Now I want to import his power Bi data into my power bi report. Is there a way to do it?

Best! 

[Anonymous]

Hi,

Under Modelling, When you right click on a Table, You have an Option to Copy Table. I would suggest that you copy and paste this Table into an Excel File and Import this Excel file into your Power BI Model.

Best Regards,
Vignesh M

If what I suggested worked for you, feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue. 🙂

[Mariusz]

Hi @Anonymous 

Your colleague can create a dataflow in the service and give you access to it.
https://powerbi.microsoft.com/en-us/blog/introducing-power-bi-data-prep-wtih-dataflows/

The second option is, he can publish dataset and give you access to that.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.