Forum Discussion

shabbirk's avatar
shabbirk
New Member
7 years ago

Scheduled Refresh Error

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 ref...
Need Help
GilbertQ's avatar
GilbertQ
Super User
7 years ago

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's avatar
v-frfei-msft
Community Support
7 years ago

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's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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