Why do I have this Error, what is the table of the Error

[luis-martins]

Hello guys!

Thank you in advance for your time!

My question is, in this moment I have a dataset with aprox. 50 tables, diverses DataBase and Worksheets. 

And I have this Error " The key didn't match any rows in the table", I know what is the problem because recently one of my collegue change the name of a sheet that we are using. 

But my question is, Is possible to know with the Request ID and the Activity ID which table have the error (API ou some webpage)?

Because if I didn't know this alteration I would have to run the model in my desktop, see which table has the error and solve to republish the dataset right?

Thank you

[edhans]

yeah, even if you can get the specific table from the service, you still have to go fix in the Desktop, so I almost always start with the source PBIX anyway.

[luis-martins]

Hello,

Yeah, so doesn't exist a way to know?

Thank you

[edhans · Accepted solution]

Not unless someone knows of a PowerShell command to get it. Tables in Power BI are associated with ID numbers, not names. Those are friendly names for your use. The error logs don't always return user friendly info.

[luis-martins]

Oh ok I see, Thank you, I guess I have to continue to solve and change my code to avoid this type of error.