Possible to load SQL table data into a flow or SPO list?

[OneWithQuestion]

I saw that PBI now has those data flow features.

Is there anyway I can use those to query my SQL server (which PBI already talks to with my data gateway) and then push those rows into an SPO list?

My goal is to load our product table into an SPO list to use for lookups.  Currently people are free hand typing in product SKUs and...it's an awful mess 🙂

If I could load the SKU and the prod description into an SPO list that would be perfect.

The catch is we don't use SQL Azure so...I would need to source it from our SQL server.

[Anonymous · Accepted solution]

@OneWithQuestion,

It is not possible to load SQL table data into SharePoint online list in Power BI.

However, you can take advantage of Microsoft Flows to achieve this requirement, for more details, please review this blog:https://www.c-sharpcorner.com/blogs/microsoft-flow-to-read-data-from-sql-and-write-to-sharepoint-lis....

And if you have any questions about Flows, please post the question in Flows forum to get dedicated support.

Regards,

Lydia