Forum Discussion

tvaishnav's avatar
tvaishnav
Icon for Helper IV rankHelper IV
4 years ago
Solved

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?

Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    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


1 Reply

  • Hariharan_R's avatar
    Hariharan_R
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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