Jun 24 2020 08:12 AM - edited Jun 24 2020 08:14 AM
So this is my first post to Microsoft Tech Community. Wondering if I am doing this right?
(see image below)
I am developing an Excel Power Query solution. This is my first Power Query... it is coming along. However, my supervisor has asked to post this in Microsoft Teams such that it can be both updated and opened (from within Teams or in . On my first effort, the data sources, csv and xlsx could not be updated. After a little research, I am assuming this is because they were from Get and Transform from both files and folders, but rather should be in a form compatible with SharePoint
I believe I need to perhaps get these data sources into a Excel Tables and then use Excel > Design > Export Table to SharePoint List. Then rebuild my main Excel file and Get the Data from SharePoint Online Lists. There looks to be several options...
So I have the following few questions: