This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I am not sure what is going on. I cannot get this pull from SharePoint folders to work. I did the same thing through Data Flows..I get data but when I use excel and do the same thing I get this error. This is driving me bonkers, how do I figure out which file is the issue and how to rectify. This error is not helpful at all.
Solved! Go to Solution.
Hi @wherdzik ,
Does your SharePoint folder contain files of different types e.g. .xlsx, .csv etc.?
It's possible that when you run the SharePoint Folder Connector wizard, it's attempting to build the connection using the wrong file type connector.
Pete
Proud to be a Datanaut!
Hi @wherdzik ,
Does your SharePoint folder contain files of different types e.g. .xlsx, .csv etc.?
It's possible that when you run the SharePoint Folder Connector wizard, it's attempting to build the connection using the wrong file type connector.
Pete
Proud to be a Datanaut!
Yes it does, I manged to filter out a lot of the files and I got it to work. I think this was the issue. Sorry I should have made a post back.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.