Forum Discussion
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", Item = "xxxxxxx"]. Table = #table({"Name", "Data", "Schema", "Item", "Kind"}, {}). ;The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface. Table: xxxxxxx.Cluster URI:WABI-CANADA-CENTRAL-redirect.analysis.windows.netActivity ID:00000000-0000-0000-0000-000000000000Request ID:83a2d0d4-3037-4ddb-9248-ee08640287abTime:2024-05-13 16:19:56ZDetails
The table names in the error will change with each failed refresh. When the error occurs, I will reenter the Service Principal credentials and the refresh will work again.
Is there any way to reduce the frequency of this issue? It happens a few times a week, and although it's a quick fix, I'm not sure why it keeps happening over and over again with the same data models in different workspaces. Not every data model will fail, but if there is a failure, it is always the same ones. Also, all the semantic models are pointing to tables and views in Azure Synapse, but each model is using different tables/views and there has never been an issue with the underlying data.
If anyone has insight into the root cause of this, please let me know!