Forum Discussion
gemcityzach
Helper IV
Helper IVHow to get SharePoint.Contents import in PowerQuery to preserve the file name of an XSLX as a field?
Hey folks, I have a bunch of folders stored in SharePoint filled with various data, mostly in CSV. Each folder is a monthly snapshot of a different table from a database that we do not have a direct...
gemcityzach , Usually Power Query does not drop. But Source.Name can be name also generated because of some other field. Check if it got renamed and later dropped as not required columns in a step (remove columns)
amitchandak
Super User
Super Usergemcityzach , Usually Power Query does not drop. But Source.Name can be name also generated because of some other field. Check if it got renamed and later dropped as not required columns in a step (remove columns)
gemcityzachHelper IV
Helper IVLooks like PowerQuery did automatically drop that column but I was able to modify it in the Steps to fix it and add it back in