Combining Excel Files from SharePoint Document Library, Combinging Specific sheet Name|Power Query|Excel Forum|My Online Training Hub

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.

https://community.fabric.micro.....-p/3526260