The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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--
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
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |