Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tvaishnav
Helper IV
Helper IV

Mashing tables from two different datamart

I have a situation where users want to create reports. But later want to use tables from those reports into another report.

 

I can think of doing this via 

  • dataset : Connect to multiple Power BI datasets and pull data tables from those to build new reports.
  • dataflow : Just created tables within dataflow and let users pull tables as needed.
  • datamart : I am not sure how to go about this.

What is the best way to move further in this situation?

1 ACCEPTED SOLUTION
Hariharan_R
Solution Sage
Solution Sage

Hi @tvaishnav 

Dataflow is the right option for your scenario. You can build a dataflow for that table and that dataflow table can be used on different datasets. 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


View solution in original post

1 REPLY 1
Hariharan_R
Solution Sage
Solution Sage

Hi @tvaishnav 

Dataflow is the right option for your scenario. You can build a dataflow for that table and that dataflow table can be used on different datasets. 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors