Cannot connect to Sharepoint file

[TiborTuboly]

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

[v-shex-msft]

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

[TiborTuboly · 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.