https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/4335458#M58733 <P>Hi @Anonymous</a>&nbsp;, Please try to achieve your transformation in MySQL query and follow the steps as per learning documents to implement incremental refresh and check once again</P> Wed, 18 Dec 2024 17:04:49 GMT skparavind_1994 2024-12-18T17:04:49Z https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/3831025#M51712 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="paramters" style="width: 209px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076834i7B3413883FC39926/image-size/large?v=v2&amp;px=999" role="button" title="Vishal_Kumar_R_2-1712838587692.png" alt="paramters" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">paramters</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="date colume" style="width: 195px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076833iB74E89843968CC34/image-size/large?v=v2&amp;px=999" role="button" title="Vishal_Kumar_R_1-1712838573489.png" alt="date colume" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">date colume</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="incremental refersh" style="width: 764px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1076831iE51DEED3B527D8B5/image-size/large?v=v2&amp;px=999" role="button" title="Vishal_Kumar_R_0-1712838498613.png" alt="incremental refersh" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">incremental refersh</span></span></P><P>&nbsp;</P><P>Hi&nbsp;</P><P>&nbsp; I am using mysql database to connect power bi i will import the data from mysql database with adavance option by optimizing the query but query folding is not happing&nbsp; and for incremental refersh i have created a paremertes and filter in the date/time column accordingly but still it showing for incremental refersh you need to create paramter it showing&nbsp; <SPAN>Any suggestions would be a great help</SPAN></P> Thu, 11 Apr 2024 13:17:33 GMT https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/3831025#M51712 Anonymous 2024-04-11T13:17:33Z https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/3832682#M51721 <P>HI&nbsp;@Anonymous</a>,</P> <P>I'd like to suggest you take a look at the official document about incremental refresh configuration and usages if helps for your scenario:</P> <P><A href="https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview" target="_blank">Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn</A><BR />Regards,</P> <P>Xiaoxin Sheng</P> Fri, 12 Apr 2024 05:54:32 GMT https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/3832682#M51721 Anonymous 2024-04-12T05:54:32Z https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/4335458#M58733 <P>Hi @Anonymous</a>&nbsp;, Please try to achieve your transformation in MySQL query and follow the steps as per learning documents to implement incremental refresh and check once again</P> Wed, 18 Dec 2024 17:04:49 GMT https://community.fabric.microsoft.com/t5/Developer/Query-Folding-incremental-refersh/m-p/4335458#M58733 skparavind_1994 2024-12-18T17:04:49Z