import mode - duplication

[Rafaelpalma]

Hello everyone, everything good? I have some reports with "import" mode to get the data from SQL. I noticed that whenever I update the data, it's duplicating the data. Is there a way to solve this?

[lbendlin]

Please be more specific.  What do you mean by "update" ?  Are you writing to the SQL table from Power Query?  That can indeed lead to to duplication of data when Power Query misbehaves.

Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? Chris Webb's BI Blog (crossjoin.co...