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 refreshing.

Need Help

4 Replies

  • 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