cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
etrietsch Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
etrietsch Frequent Visitor
Frequent Visitor

Re: GENERATESERIES() function limited to 32766 rows?

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 5
Super User
Super User

Re: GENERATESERIES() function limited to 32766 rows?

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




etrietsch Frequent Visitor
Frequent Visitor

Re: GENERATESERIES() function limited to 32766 rows?

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

etrietsch Frequent Visitor
Frequent Visitor

Re: GENERATESERIES() function limited to 32766 rows?

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!

Re: GENERATESERIES() function limited to 32766 rows?

https://docs.microsoft.com/en-us/dax/generateseries-function


@etrietsch wrote:

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


 

etrietsch Frequent Visitor
Frequent Visitor

Re: GENERATESERIES() function limited to 32766 rows?


@ShivendooKumar wrote:

https://docs.microsoft.com/en-us/dax/generateseries-function


I have read the documentation on this function. How is this answering the question?