https://community.fabric.microsoft.com/t5/Report-Server/Switch-to-import-mode/m-p/3048933#M28587 <P>Remove all relations &gt; import your data &gt; and then set relations</P><P>&nbsp;</P><P><FONT color="#3366FF">______________________________________________________</FONT></P><P><FONT color="#3366FF"><SPAN>If you found this post helpful, please give</SPAN><STRONG><SPAN>&nbsp;</SPAN>Kudos</STRONG><SPAN>&nbsp;</SPAN><FONT face="Wingdings" size="5">C</FONT></FONT></P> Sun, 29 Jan 2023 13:30:58 GMT freginier 2023-01-29T13:30:58Z https://community.fabric.microsoft.com/t5/Report-Server/Switch-to-import-mode/m-p/3046870#M28558 <P>I have a problem with the switch from direct Query mode to import mode,&nbsp; I have to qualify fo conditions like "no space" , or "no duplicates" but when I want to delete the duplicates or the spaces in my table it says it can't be done in direct Query mode. So I can't have the conditions to switch to Import mode because I'm the direct Query mode. So I don't know how to do.&nbsp;<img /></P> Fri, 27 Jan 2023 09:26:43 GMT https://community.fabric.microsoft.com/t5/Report-Server/Switch-to-import-mode/m-p/3046870#M28558 Wessvel_hl 2023-01-27T09:26:43Z https://community.fabric.microsoft.com/t5/Report-Server/Switch-to-import-mode/m-p/3048933#M28587 <P>Remove all relations &gt; import your data &gt; and then set relations</P><P>&nbsp;</P><P><FONT color="#3366FF">______________________________________________________</FONT></P><P><FONT color="#3366FF"><SPAN>If you found this post helpful, please give</SPAN><STRONG><SPAN>&nbsp;</SPAN>Kudos</STRONG><SPAN>&nbsp;</SPAN><FONT face="Wingdings" size="5">C</FONT></FONT></P> Sun, 29 Jan 2023 13:30:58 GMT https://community.fabric.microsoft.com/t5/Report-Server/Switch-to-import-mode/m-p/3048933#M28587 freginier 2023-01-29T13:30:58Z