Parameters Haven't Been Defined For Your Data Set

Good Afternoon -

I am working with some 300+M row data sets and am attempting to set up incramental refresh so as not to kill our SQL DB on daily refreshes.

I believe that I followed the instructions correctly on setting up incramental refresh but am still having issues. I have tried this with two different data sets and am getting the same issue on both. I assume there is a step somewhere that I am missing but I cannot seem to figure it out.

1. I created my date parameters (RangeStart and RangeEnd)

2. I filtered my fact table by the parameters, making sure that one was set to equals and one was set to on or equals

3. I applied my changes and set up the refresh on the fact table I wanted and clicked Apply All

4. I published my data set to the cloud, mapped my data sources using my cloud gateway, refreshed the data set manually and when i go look at the settings, I see this.

I already tried deleting the data set, republishing and refreshing again but got the same error. I have to be missing something step wise but cannot figure out what it is. If anyone has ever experienced this or has an reccomendations on how I can get this working, I would appreciate the help.

Thanks,

Matt

Need Help

Tips and Tricks

16 Replies

collinq
Super User
6 years ago
Hi matthew_hampton ,

Just to confirm - your RangeStart and RangeEnd parameters are set as Type "DateTime" (NOT just Date) and "AnyValue" in suggested value? Also, in the Incremental Refresh page setting the DAWloaddate (hard to read...that might be misspelled by me) is NOT the same date being used for the Range Start and End, right? (I don't think it is but want to confirm.)

Let me know.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
- matthew_hampton
  Helper I
  6 years ago
  collinq
  
  Thanks for the response.
  
  I did double check - both paramters are of type Date/Time and both have any value listed under suggest value.
  
  If I am understanding your second question correctly, I am filtering my import using the parameters on DAWLoadDate. That is the date/time stamp for when the row is inserted into our warehouse and I want to only pull back the new rows based on that. Is there something else I need to change on that front to get the parameters to work properly?
  
  LMK if I did not interpret your second question correctly.
  
  Thanks again!
  
  Matt
  - collinq
    Super User
    6 years ago
    Hi matthew_hampton ,
    
    New theory - your RangeEnd, did you put the "9999" in there? Maybe change that to "2025" for right now just to see if it works then.
    
    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Anand24
Super User
6 years ago
Hi matthew_hampton ,

This kind of error usually appears when either data type conflict is present in parameters or data source is not mentioned properly since data source also is a parameter in power query editor.
It will be best if you re-check these 2 and then try refreshing in services.

You can always raise a ticket to MS support from here for dedictaed help if this is very urgent.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
- matthew_hampton
  Helper I
  6 years ago
  Hello Anand24
  
  I did verfiy that the date field I am applying the parameters to is a date/time, as is the parameter, so that part checks out for me.
  
  I am not sure I understand what you are saying in the second part that the "data source is not mentioned properly since data source also is a parameter in power query editor."
  
  Can you shed some more light on what that means how I would go about ensureing that it is mentioned properly?
  
  I will likely open up a ticket today with MS.
  
  Thanks,
  
  Matt
  - Anand24
    Super User
    6 years ago
    Hi matthew_hampton ,
    
    1st and 2nd line in the M code. Mainly the 1st line. Make sure it is correctly given for your source. Power BI automatically creates these 2 lines of M Code but sometimes issues do exist here too.
    
    Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Anonymous
Not applicable
6 years ago
The year 9999 is what's causing your issue. The range end and start dates doesn't actually matter. it is the dates/timeframe you entered into the incremental refresh window that matter.

double check to make sure parameters are date time fields then change year of end date and it should work fine.
- matthew_hampton
  Helper I
  6 years ago
  Hello Anonymous
  
  I tried a couple of different ways - I changed RangeEnd to 12-31-2025 and then to 12-31-2020, deleted the data sets, republished and refreshed and am still getting the error that the parameters are not defined.
  
  Thank you for the suggestion. I will keep working towards finding a solution.
  
  Matt
BG123
Frequent Visitor
5 years ago
Any luck? I am having the same issue. I had it working when I first went through all of these steps as mentioned above but then at some point in devleopment/publishing, I get same "Parms havent been defined for this datase..." error...
PowerBIShan
Frequent Visitor
3 years ago
matthew_hampton
Did you find any solution to this issue?