True False value turning into 0 -1 on Gateway Refresh

[itanic]

Have developed datasets that have a calendar that uses the M expression for Date.IsInPreviousNMonths that returns a "TRUE" or "FALSE" value.  Everything has been working just fine - up until we installed the gateway and scheduled a refresh of the data.  With the auto refresh of data, many of the report tabs showed no data.  Turns out that the "TRUE/FALSE" values (used as filters) turned into "0" or -"1".  Don't know how to fix this so the refresh works as expected. 

Anyone else seeing this?

[Anonymous]

Hi @itanic,

How did you set up the calendar table, can you share more detail information?

In addition, you can also refer to below article to provide more contents to help troubleshooting.

Troubleshooting the on-premises data gateway

Regards,

Xiaoxin Sheng

[itanic]

The calender is created via query and the commend for the field at issue is created using the following

= Table.AddColumn(#"Added Custom13", "Last 12 Months", each Date.IsInPreviousNMonths([Date], 12))

Hope this helps

[Anonymous]

Hi @itanic,

I copy your formula and test on my side, I can reproduce your issue.

I found if you set custom column with text format, the issue will appeared; but if you convert it to bool(true/false) type, it also works on service side.

Regards,

Xiaoxin Sheng