Forum Discussion

andrew_armst's avatar
andrew_armst
New Member
5 years ago
Solved

Presenting data from multiple tables

Hi all,   I am new to powerBI to please forgive my ignorance or bad explination.     We have 6 identical sharepoint lists that we want to combine into a PowerBI dashboard.  We have one list per c...
Need Help
  • jairoaol's avatar
    jairoaol
    5 years ago

    each list creates a column with the name of the site to which they correspond.

    then if you perform the append process.

Cseneff's avatar
Cseneff
New Member
5 years ago

Hi Andrew,

 

Could you combine all the tables then add a new column that ID's the site?

  • andrew_armst's avatar
    andrew_armst
    New Member
    5 years ago

    I thought about trying that, but the data is constantly being added too.  I didn't know if the new records would fill in the new column.  I could amend the form and lists to incliude the sites.   But if there is a way of doing this via power BI then I would rather do that.

     

    I should note I have combined the tables into one table to test out an overall corporation view.