Need help on how best to design my data model

[abrownRPI]

Hi all,

My company has a SharePoint site for each project that we are working on. Each SharePoint site has 11 lists which we use as checklists to track progress through the different phases of the project. I currently have a pbix for each project. I pull in each of the 11 lists into the data model and then I append them into 1 table so it's easier to create visuals for. In BI Web I have all of these project reports rolling into 1 dashboard but the dashboard is becoming very full and difficult to maintain.

I would like to have all of this in one pbix with all of the individual project checklists all appended to 1 big master table. This way I would have 1 report instead of separate ones for each project.

For example, say I have 15 projects with 11 SharePoint lists for each, that will be 165 individual data sources. Is that doable? Is that unwise to try to pull in that many sources? I would appreciate any ideas. Thank you very much

[Anonymous]

Hi @abrownRPI ,

Do all the sharepoint lists follow the same schema? If so, Try to dump the data in a sql database onto a single table and try connecting Power BI to this database.

Or You can try appending all the lists somehow. Handling 165 different sources would be a Herculean task.