Forum Discussion

emmamilk's avatar
emmamilk
New Member
2 years ago

Dataset refresh error in Power BI workspace with Service Principal

Hi all,   I am seeing the below error with dataset refreshes across multiple workspaces and semantic models.    Expression.Error: The key didn't match any rows in the table = [Schema = "xxxxxxx",...
Need Help
GilbertQ's avatar
GilbertQ
Super User
2 years ago

Hi emmamilk 

 

Could this possibly be when the data is being read from the table? It is not a complete table What I mean by that possibly is that the data is being loaded into the table at the same time it is being read and that is why it cannot find keys in the rows.

emmamilk's avatar
emmamilk
New Member
2 years ago

Hi GilbertQ, I don't think that is the case because some data models have a refresh triggered at the end of an ETL job in ADF, and some are scheduled to refresh in the PBI workspace hours after the data load is complete.

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi emmamilk 


    Can you confirm that the tables do have all the data when the error occurs?

    • emmamilk's avatar
      emmamilk
      New Member
      2 years ago

      Hi GilbertQ, yes the tables do have all of the data, I have not noticed an issue with the tables.

      • GilbertQ's avatar
        GilbertQ
        Super User
        2 years ago

        Hi emmamilk 

         

        If that is the case, it would appear that something else is going on and I would suggest logging a support ticket.