Forum Discussion
LYeo87
Helper II
Helper IIMultiple Sharepoint Lists - 1 PowerBI report
Hello.
Has anyone had a scenario where more than one sharepoint list, with the same structure, has been used to pull through to one one view of data? If so, whats the best way to acheive this? And can it be edited to add new lists when created?
Laura
Hi LYeo87
I have done something similar like this:
- Connect to SharePoint Online List
- Delete the Navigation step from Applied Steps
- Apply a filter to the Title column (this assumes all lists have similar names)
Use Choose Columns to get rid of all the columns except Title and Items - Expand the Items choose the list columns to keep
- Profit
If this helps please mark as a solution for others to find 🙂
Check out our free Power BI (and more) video courses.
1 Reply
- SamWiseOwl
Super User
Hi LYeo87
I have done something similar like this:
- Connect to SharePoint Online List
- Delete the Navigation step from Applied Steps
- Apply a filter to the Title column (this assumes all lists have similar names)
Use Choose Columns to get rid of all the columns except Title and Items - Expand the Items choose the list columns to keep
- Profit
If this helps please mark as a solution for others to find 🙂
Check out our free Power BI (and more) video courses.