Forum Discussion
EnzoP
4 months agoNew Member
An error occurred while processing the semantic model - ErrorCode = 10061
Hi all, I get the error message below and I'm unable to identify where in my queries I'm making a reference to "Positions overview"
I get that message when I'm trying to update my report from PowerBI service, and my sources are 7 Excel in a SharePoint & on SQL Azure base.
"An error occurred while processing the semantic model.
Details :
- Data source error
- Expression.Error: The key didn't match any rows in the table..
- Microsoft.Data.Mashup.ErrorCode = 10061.
- Key = [Name = "Positions overview"].
- Table = #table({"Name", "Data", "Item", "Kind", "Hidden"}, {}). .
- The exception was raised by the IDbCommand interface.
2 Replies
- EnzoPNew Member
Issue solved :
One of the source, a weekly Excel report, has changed its sheet name from "Position overview" to a french translation, so PowerQuery could not find the table.Thanks for your help.