Re: Scheduled Refresh Error

shabbirk · ‎11-14-2018

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 · ‎11-14-2018

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?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

v-frfei-msft · ‎11-15-2018

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

v-frfei-msft · ‎11-30-2018

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.