cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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) 

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 105 members 1,931 guests
Please welcome our newest community members: