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 ,

 

 

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