Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I was trying to implement Incremental load. But I wasn't sure where Iam going wrong
I have created parameter(RangeStart and RangeEnd) and filtered the date column based on the parameter.
But Iam getting the error like this
Checked the article related to incremental load where they have mentioned.
But my date table format is in MMDDYYY
So is this the reason why Iam facing error or I have missed the steps?
If date format is the reason for failure .Kindly let me know how to change the format from MMDDYYYY to YYYYMMDD(I have tried by seperating using delimeter and meriging it and while changing format from text to date the format is getting changed )
Kindly let me know the solution
Solved! Go to Solution.
Hi @Joseph_11 ,
There can be only one equal to.
The type of the parameter should be Date/Time, please fix and then test.
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Joseph_11 ,
Whether query folding is supported is determined by the type of data source you select and cannot be changed.
If you have more relevant questions, you can create a new post in the forum so that we can pay attention to it and solve it.
Best Regards,
Gallen Luo
Hi @Joseph_11 ,
If a table configured with incremental refresh does not support query folding, the goal of incremental refresh cannot be achieved.
Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.
Query folding - Power Query | Microsoft Learn
Best Regards,
Gallen Luo
Hi @v-jialluo-msft
Got your point..Thanks for sharing your content.
In the below screenshot till renamed columns query folding is available and it got broken after the following steps
Is it possible to enable query folding for this step(Filtered rows), Since the above steps are created by my senior colleagues I don't want to make any changes it the steps.
Regards,
Joseph
Hi @Joseph_11 ,
There can be only one equal to.
The type of the parameter should be Date/Time, please fix and then test.
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-jialluo-msft
Thanks for the quick response.
As per your instruction I have followed it and now Iam able to enbale the incremental load but I get this error message
Is this error was reported since the query folding is not happening? and will it cause any issue If I proceed with incremental load.
Regards,
Joseph
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.