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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi All,
when I try to connect to a Sharepoint file, Power BI desktop gives the following error message:
An error occurred in the ‘XY' query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=Record
Table=Table
I read that in this case I should refresh the preview of source step in the query editor, but it does not work for me.
Do you have a solution for this case?
Thank you.
Tibor
Solved! Go to Solution.
Hi.
When I would like to load a Sharepoint file, it also creates a sample file in a separate query (transform file from query). I went to the source step of this sample file and I filtered for the Sharepoint file I wanted to load (by default, this step lists all the files available on the Sharepoint). It solved the problem.
Hi @TiborTuboly ,
I'd like to suggest you take a look at following link to use odata feed connection to get data from sharepoint:
Error with Get Data from SharePoint Online document library - Expression.Error: The key didn't match
Regards,
Xiaoxin Sheng
Hi.
When I would like to load a Sharepoint file, it also creates a sample file in a separate query (transform file from query). I went to the source step of this sample file and I filtered for the Sharepoint file I wanted to load (by default, this step lists all the files available on the Sharepoint). It solved the problem.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.