Forum Discussion

matthew_hampton's avatar
matthew_hampton
Icon for Helper I rankHelper I
6 years ago

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 ins...
Anand24's avatar
Anand24
Icon for Super User rankSuper 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's avatar
matthew_hampton
Icon for Helper I rankHelper 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