GENERATESERIES() function limited to 32766 rows?

[etrietsch]

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

[Anonymous]

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]

---

@Anonymous wrote:

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

---

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

[etrietsch · Accepted solution]

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!

[MFelix]

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]

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