Scheduled Refresh Error

[shabbirk]

I have build up the schedule refresh. When i am refreshing my model on power BI desktop there is no error shows, but in power bi service it says one of my table have duplicate value and it is not refreshing.

[GilbertQ]

Hi @shabbirk

Can you confirm that you have got the latest version of the On-Premise Data Gateway installed?

Also possibly on the table where it is saying there are duplicate values, are you able to add in a step to remove duplicates in the Power Query Editor?

And finally, do you click on Refresh when in Power BI desktop, which will refresh ALL the datasets?

[v-frfei-msft]

Hi @shabbirk,

Please check the relationship of your tables and disable the option Autedetect new relationships after data is loaded as below. Afther that, please recreate the relationship between tables and try again.

Regards,

Frank

[v-frfei-msft]

Hi @shabbirk,

Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

Regards,

Frank

[shabbirk]

See here are snapshots for model.