Connecting Excel Report to SharePoint List

[CCSlice]

Hello Mr.Excellians!

I have created an Excel report that pulls the data from a SharePoint list using PowerQuery, but the data and columns pulled in are "not live", meaning that they don't connect to the SharePoint list. Is there a way either in PowerQuery or the Excel worksheet itself, that I can have the ability to change data and have that corresponding change update in SharePoint?

Thanks in advance, for your help.