Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a template report

I have loaded my dataset which is a series of 10 sharepoint lists. The columns are identical for each of the lists. Obviously the data is different. Can I design the report for List 1 on Page 1 and then somehow copy it to list 2 (on Page 2), list 3 (on Page 3), etc.

 

Then one of the pages will have a different report visuals to combine certain columns from each of the list.

 

Thank you

  • Hi Anonymous 

    After importing 10 sharepoint lists into Power BI, you can create a report page with visuals.

    Adding columns from List1 to these visuals,

    Then right-click and select "Duplicate Page", 

    On duplicated pages, you can change the columns from list1 to list2,3,4....ect

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous 

    After importing 10 sharepoint lists into Power BI, you can create a report page with visuals.

    Adding columns from List1 to these visuals,

    Then right-click and select "Duplicate Page", 

    On duplicated pages, you can change the columns from list1 to list2,3,4....ect

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you.