Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
TiborTuboly
Frequent Visitor

Cannot connect to Sharepoint file

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

1 ACCEPTED 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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.