Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingyeah, 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello,
Yeah, so doesn't exist a way to know?
Thank you
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingOh ok I see, Thank you, I guess I have to continue to solve and change my code to avoid this type of error.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.