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...
Need Help
Tips and Tricks
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

    • Anand24's avatar
      Anand24
      Icon for Super User rankSuper 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 !!!

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

        Hello Anand24 

         

        Here are the first two lines of my M query

         

         

        The first row is just Server then Datbase


        The second row is schema and table.

         

        From there all I do is change a data type on one unrelated field and apply the parameters.

         

        This is coming from an on-prem SQL data warehouse, if that matters for this discussion.

         

        Does anything look wrong here?

         

        Thanks,

         

        Matt