Hello All!
I am stuck. I did the exact same pull before we migrated to SP a few weeks ago and now I am encountering a bunch of issues. The task was to combine a worksheet from 20 + folders and 20+ workbooks. The files have two columns in there that are not showing up. I shared a couple of screenshots on the post I made on the PowerQuery forum. I am not getting a respond yet and I was hoping someone would also have a second look here. Sorry if the double posting is not appropriate I just know that previously when I posted a question here you guys gave me really good solutions. If you want me to take the post down for the double posting please let me know and I would be happy to comply.
For whatever reason when the data comes there are two columns which re not showing data in the PowerQuery pull the EEID# AND BILLID#. It seems like maybe it doenst like the data type? I am not sure be I have never seen this and like I said I did the same exact thing before we migrated to sharepoint and this issue did not exist.
For others reading, it appears from the link that this was down to user error, so no need to follow up on this one. 🙂
