Forum Discussion

Copper Contributor

Apr 04, 2019

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...

Microsoft Flow

SharePoint Online

NeverHere
Apr 04, 2019
RobinOrgHood Do you need to push to SQL to report? Could you just connect PowerBI to the SharePoint list and report that way?

NeverHere

Brass Contributor

Apr 04, 2019

RobinOrgHood Do you need to push to SQL to report? Could you just connect PowerBI to the SharePoint list and report that way?

RobinOrgHood
Copper Contributor
Apr 05, 2019
NeverHere
took me a while to finger out the connections, but eventually stumbled into connecting powerbi to the spo list. Way cool! great suggestion!
RobinOrgHood
Copper Contributor
Apr 05, 2019
NeverHere
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!