Forum Discussion
Slicer - Cards - 11 SharePoint Lists
Hey TxSteve ,
I recommend to make one table from the ten using Append. This article https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/ provides further information.
You just have to make sure that each list has a column that sets the Sharepoint lists apart. Create a column called team if necessary and add a constant value, then merge all the tables (10 Sharepoint lists) into one.
Hopefully, this provides some new ideas.
Regards,
Tom
Next: I recommend following this introduction to Power BI data modeling - https://docs.microsoft.com/en-us/learn/paths/model-power-bi/
Super UserHey TxSteve ,
I recommend to make one table from the ten using Append. This article https://www.poweredsolutions.co/2019/04/09/combine-or-append-data-in-power-bi-power-query-main-concepts/ provides further information.
You just have to make sure that each list has a column that sets the Sharepoint lists apart. Create a column called team if necessary and add a constant value, then merge all the tables (10 Sharepoint lists) into one.
Hopefully, this provides some new ideas.
Regards,
Tom
Next: I recommend following this introduction to Power BI data modeling - https://docs.microsoft.com/en-us/learn/paths/model-power-bi/