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
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
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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.