I have configured my data set for incremental refresh as the following manner. I have 2 main tables and 2-3 refrenced tables. Main tables having date time with refrenced tables having month column. I want to refresh data for last 9 months and after that I want to refresh only daily data.
1. Do I need 2 seprate coulumns for (Rangestart, RangeEnd) and maximum datetime column in incremental refresh setup?
On service, I am getting useless data. Cards are showing infinity, trends are getting doubled for some dates.
Thanks in advance
Solved! Go to Solution.
Hey @Minakshi ,
no, you filter the same column with the desired range.
Be sure that you set the filter of the data column properly ("is after or equal" and "if before"):
Then the refresh should work.
Also check the documentation, it's pretty well described:
@selimovd I want data to be refreshed for last 9 months. In my RangeStart (3/1/2021) and RangeEnd(5/1/2021) . Data is coming correct with March and April. For remaining months cards go blank.
can you help me with this.
>>Data is coming correct with March and April. For remaining months cards go blank.
I'm not so clear about your description, can you please explain more about these? Did you mean the refresh not affect some of the report contents?
I'm glad to hear you find the root causing and share it here.🙂
I think they will help others who faced the same scenario.
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
Join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!
Click here to read more about the May 2022 updates!