Forum Discussion
Facing error on refreshing the model
I had created a new view(pbi_part_number_dim) and published it in service. When I check the db I can see the view is created but when I refresh the model in service it shows the following error.
Underlying error message: The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Key: [Name = "PBI_PART_NUMBER_DIM"]
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 8d4b1ad3-e0e5-4e8b-82e5-16a4f9f2b9c1
Request ID: 076f2aee-1b68-67e6-9cd5-bd6698e58f3c
Time: 2020-12-31 09:46:52Z
5 Replies
Avivek , check is it permission issue on the view ?
Hi amitchandak , thanks, it took a while but it turned out to be server issue and power bi service issue. Were able to resolve it after a long time
Hi, Avivek
It’s my pleasure to answer for you.
According to your description, I think it may be that after the file was updated, the data has changed. Can it be refreshed normally in the desktop?
Maybe you have a query in which a row is selected based on a key value and that value does not exist.
To fix it make sure the key value exist or adjust the code so it does not point to a non-existing key value.
Or inconsistent data format between source data and PBI.
You need to check it.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thankyou so much v-janeyg-msft for the response,thanks, it took a while but it turned out to be server issue and power bi service issue. Were able to resolve it after a long time
Hi, Avivek
Do you mean it's back to normal now? How do you judge it is a server problem? If it’s true, I believe microsoft should fix it.
Best Regards
Janey Guo
