Forum Discussion

etrietsch's avatar
etrietsch
Frequent Visitor
7 years ago
Solved

GENERATESERIES() function limited to 32766 rows?

Hi,

 

The following code only generates 32766 rows. Is this a restriction to the function or table, or am I doing something wrong?

 

Dates = 
    GENERATE(GENERATESERIES(1;60815);
    VAR days = [value]
    Return ROW("Dates"; DATE(1880;1;days)))

Cheers

Need Help
  • etrietsch's avatar
    etrietsch
    7 years ago

    UPDATE:

     

    The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...? 

     

    After changing the code all was fine. The new code is:

    Dates = 
    GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY));
    VAR days = [value]
    Return ROW("Dates"; DATE(1880;1;1)+days))

    Thanks for the help!

5 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi etrietsch,

     

    What's the version you are on?

     

    Tried your code with February version and got 60.815 rows, no issue on my version.

     

     

    Regards,

    MFelix

    • etrietsch's avatar
      etrietsch
      Frequent Visitor
      7 years ago

      Hi MFelix I use Power BI Version: 2.66.5376.1681 64-bit (februari 2019) and Windows 10 Home (64-bit) 

  • etrietsch's avatar
    etrietsch
    Frequent Visitor
    7 years ago

    UPDATE:

     

    The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...? 

     

    After changing the code all was fine. The new code is:

    Dates = 
    GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY));
    VAR days = [value]
    Return ROW("Dates"; DATE(1880;1;1)+days))

    Thanks for the help!