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
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

    • Anand24's avatar
      Anand24
      Icon for Super User rankSuper User
      6 years ago

      matthew_hampton ,

      Doesn't seem that anything is incorrect here.

       

      Raising a Support ticket is the best way out. Link

       

      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

        Anand24 Everything looked fine to me as well. I did open a support ticket and will come back and let everyone know what the outcome is for those that are interested.

         

        Thanks for all your suggestions.

         

        Matt