Facing error on refreshing the model

[Avivek]

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.

file updated Then i refresh same error

Underlying error code: -2147467259
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

It shows error in PBI_Part_number_Dim, I am not sure why this error is showing if the view is already created. Is there a solution for this.

[v-janeyg-msft]

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.

[Avivek]

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

[v-janeyg-msft]

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

[amitchandak]

@Avivek , check is it permission issue on the view ?

[Avivek]

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