Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Incremental Refresh - need to setup parameters first but i have

Hi all,

I keep getting the below error:

1. I have set the parameters(sticking to the case sensitivity and RangeStart and RangeEnd)

2. I have filtered my tables to use these parameters.

The only issue i could see is, my Data comes in as a Date/time/zone. so i have my Parameters set to Date/Time/Zone. Would this be a problem?

Should i change the date type in my main table to Date/time?

or is there another reason why i can't set my incremental refresh?

TomMartens
Super User
5 years ago
Hey Anonymous ,

you have to stick to the datatypes described in this article: Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs

Hopefully, this provides what you are looking for.

Regards,

Tom
- Anonymous
  Not applicable
  5 years ago
  So i've tried changing the data type to date/time so that the Parameters can filter my Fact table.
  
  However it's taken so far an hour to apply the changes. I don't have a lot of data it's 28MB of data/300,000 rows
- Anonymous
  Not applicable
  5 years ago
  I'll accept this as the solution. While the documentation didn't explicity say to stick to Date/Time.
  It worked when i changed my Fact Table to Date/Time(from Date/Time/Zone) and kept my Parameters as Date/Time.
Anonymous
Not applicable
3 years ago
Also make sure you dont have a space in between you parameter names. - (I deleted the gap and then it worked) 🙄