Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
This is my data source in Power Query:
= SharePoint.Contents("https://xxx-my.sharepoint.com/personal/zzzz/Documents/Power/")
I want to get all the files in a folder in OneDrive for business.
However, this is returning:
DataSource.Error: SharePoint: Falha do pedido: O servidor remoto devolveu um erro: (400) Pedido incorrecto. (Bad Request)
Detalhes:
DataSourceKind=SharePoint
DataSourcePath=https://xxx.sharepoint.com/personal/zzz/Documents/Power
SPRequestGuid=804aa99f-f0a7-2000-7b4e-309f35dbdc66
Url=https://xxx-my.sharepoint.com/personal/zzz/Documents/Power/_vti_bin/ListData.svc
The URL is valid and I have logged in to the respective Microsoft account.
Hi @webportal ,
Glad to hear that you have worked it out. Could you please kindly accept @lbendlin reply as the solution.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you sure you want to give other users access to your personal sharepoint? You may want to consider using a team sharepoint instead.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!