https://community.fabric.microsoft.com/t5/Report-Server/Reduce-data/m-p/3074298#M28816 <P><SPAN>you may consider using DirectQuery or Live Connection instead of Import</SPAN></P><P>&nbsp;</P><P><SPAN>Or you can use two different databases; one with reduce data to develop on destop, and the other one with a full data that you can connect the report after deploying&nbsp;</SPAN></P> Fri, 10 Feb 2023 10:26:52 GMT jaweher899 2023-02-10T10:26:52Z https://community.fabric.microsoft.com/t5/Report-Server/Reduce-data/m-p/3072776#M28808 <P>I'm on premise and have a billion row data set. Whilst loading import from desktop it crashing out at 10 million. My question is if I reduce the dataset in desktop on my local machine build the report then will the refresh work from the published report with full dataset.</P> Thu, 09 Feb 2023 18:18:10 GMT https://community.fabric.microsoft.com/t5/Report-Server/Reduce-data/m-p/3072776#M28808 Anonymous 2023-02-09T18:18:10Z https://community.fabric.microsoft.com/t5/Report-Server/Reduce-data/m-p/3074298#M28816 <P><SPAN>you may consider using DirectQuery or Live Connection instead of Import</SPAN></P><P>&nbsp;</P><P><SPAN>Or you can use two different databases; one with reduce data to develop on destop, and the other one with a full data that you can connect the report after deploying&nbsp;</SPAN></P> Fri, 10 Feb 2023 10:26:52 GMT https://community.fabric.microsoft.com/t5/Report-Server/Reduce-data/m-p/3074298#M28816 jaweher899 2023-02-10T10:26:52Z