Expression.Error: The key didn't match any rows in the table. Details: Key= Schema=dbo Item=vFactSales Table=[Table]

student training 0 Reputation points
2024-06-15T21:39:56.1133333+00:00

The AdventureWorksDW20XX.pbix Power BI lesson file for the Exercises has no vFactSales table in the data model so the "Sales" and "Sales Order" tables do not display data when looked at in the Transform data dialog box, as they reference a non-existent table, (as seen in the Home>Query>Advanced Editor)

dbo_vFactSales = Source{[Schema="dbo",Item="vFactSales"]}[Data],

therefore producing error:

Expression.Error: The key didn't match any rows in the table.

Details:

Key=

    Schema=dbo

    Item=vFactSales

Table=[Table]

This question is related to the following Learning Module

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
219 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Syed Saleem Peera 2,445 Reputation points Microsoft Vendor
    2024-06-19T04:17:56.4933333+00:00

    Hi student training,

    Thank you for reaching out to us on Microsoft Q&A forum.  

    We tried from our end; it's working fine for us. Kindly refer the below screenshots.

    "Clear the browser history and start again. This will remove all traces of your previous activity, allowing you to browse with a fresh start."

    User's image User's image

    If you are still facing any issue, please let us know in the comments. We are glad to help you.

    If the information is helpful, please Accept Answer so that it would be helpful to community members.

    Thank you.