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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Greg0ry
Helper II
Helper II

Updating powerbi data from a sharepoint stored table

Hello, I get an error message when I update a table stored in a sharepoint. I don't understand why. Can you help me? Here is the error message: "The key did not match any rows in the table". Here is another error message: An error occurred in the query “BDD LR”. Expression.Error: The key did not match any rows in the table.
Details :
Key=
Name=BDD LR and NI.xlsx
Folder Path=https://allianceautomotive.sharepoint.com/sites/msteams_af71a0_411063/Shared Documents/GENEVE OCCASION CA & Indicateurs/
Table=[Table

1 ACCEPTED SOLUTION
Akash_Varuna
Solution Sage
Solution Sage

Hi @Greg0ry It might be because the path has been changed and the table is not at at the older path could you re check that try reconnecting with sharepoint after removing the connection make sure you have credentials 

View solution in original post

2 REPLIES 2
christinepayton
Super User
Super User

You might want to redact your SharePoint URL. But like the other commenter mentioned, this happens when you reference things by name or path and the name or path changes. You can update references in the advanced query editor-- 

Akash_Varuna
Solution Sage
Solution Sage

Hi @Greg0ry It might be because the path has been changed and the table is not at at the older path could you re check that try reconnecting with sharepoint after removing the connection make sure you have credentials 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.