Forum Discussion
Solved
flow to sync SPO list with SQL table
so I'm developing in SPO and got into an issue with >5k list items. Fixed that with creative filtered views, then another issue sprang up. The list in question now has 7500 or so items in it, and...
RobinOrgHood Do you need to push to SQL to report? Could you just connect PowerBI to the SharePoint list and report that way?
RobinOrgHood Do you need to push to SQL to report? Could you just connect PowerBI to the SharePoint list and report that way?
I have experienced powerbi, but usually doing data modeling.
NeverHere wrote:RobinOrgHood Do you need to push to SQL to report? Could you just connect PowerBI to the SharePoint list and report that way?
I have never "connected it to SharePoint", but since you are the second today to suggest this, it sure is on my list of things to explore. Any more hints on steps to take would be appreciated!