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

Question

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

Answer 1

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."

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.