https://community.fabric.microsoft.com/t5/Developer/Creating-connection-to-the-model/m-p/2283050#M33874 <P>Hi @Anonymous</a>&nbsp;,</P> <P>&nbsp;</P> <P>If you encounter this issue when transform data, it is likely to cause query performance issues due to merge and append.Please refer to this thread:</P> <P><A href="https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/m-p/584292" target="_self">https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/m-p/584292</A>&nbsp;</P> <P>If the report is refreshed, too large models may cause slow loading.<SPAN>For queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report.</SPAN></P> <P><A href="https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh" target="_self">https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh</A>&nbsp;</P> <P><BR />Best Regards,<BR />Liang<BR />If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 14 Jan 2022 05:39:59 GMT V-lianl-msft 2022-01-14T05:39:59Z https://community.fabric.microsoft.com/t5/Developer/Creating-connection-to-the-model/m-p/2275121#M33823 <P>i have a report . its was working on previous data . but today i got stuck with <STRONG>Creating connection to the model</STRONG> Message .&nbsp; please find the below screen shot.</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="THENNA_41_0-1641809580557.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/654099iEF2F4B98F0178CE5/image-size/medium?v=v2&amp;px=400" role="button" title="THENNA_41_0-1641809580557.png" alt="THENNA_41_0-1641809580557.png" /></span></P><P>Thanks in advance .&nbsp; Looking for support .</P> Mon, 10 Jan 2022 10:15:50 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-connection-to-the-model/m-p/2275121#M33823 Anonymous 2022-01-10T10:15:50Z https://community.fabric.microsoft.com/t5/Developer/Creating-connection-to-the-model/m-p/2283050#M33874 <P>Hi @Anonymous</a>&nbsp;,</P> <P>&nbsp;</P> <P>If you encounter this issue when transform data, it is likely to cause query performance issues due to merge and append.Please refer to this thread:</P> <P><A href="https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/m-p/584292" target="_self">https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/m-p/584292</A>&nbsp;</P> <P>If the report is refreshed, too large models may cause slow loading.<SPAN>For queries for which the source data is not updated often or at all, it makes sense to not have the queries included in the refresh of the report.</SPAN></P> <P><A href="https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh" target="_self">https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh</A>&nbsp;</P> <P><BR />Best Regards,<BR />Liang<BR />If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 14 Jan 2022 05:39:59 GMT https://community.fabric.microsoft.com/t5/Developer/Creating-connection-to-the-model/m-p/2283050#M33874 V-lianl-msft 2022-01-14T05:39:59Z