topic Re: . Error: 'The start date or end date in Calendar function can not be blank value. in Report Server

. Error: 'The start date or end date in Calendar function can not be blank value.

Jays — Thu, 27 Jun 2024 13:50:36 GMT

Hi,

I am facing an error of UTCNOW(), While loading data for analysis service for the first time in the database it shows the error:
Failed to save modifications to the server. The error returned: 'The start date or end date in Calendar function can not be Blank value.

Here I am trying to process tables and load the data from the analysis service, but there is no data in those tables.
All the measures work correctly in different databases. I created a new DB for the new requirement with the same data.
But here in the new DB I am trying to process tables without data for the first time. I can not understand the behavior of the server. please help me here.

Thank you.

Re: . Error: 'The start date or end date in Calendar function can not be blank value.

lbendlin — Fri, 28 Jun 2024 00:47:48 GMT

You are using CALENDAR() in your DAX code, and one of the date boundaries is incorrect. Check your code.

Re: . Error: 'The start date or end date in Calendar function can not be blank value.

Jays — Fri, 28 Jun 2024 06:25:40 GMT

HI, Thank you for your reply, but I am facing error in UTCNOW() , I uam using calendar() but it has both the values, startdate and end date.

Here, I want to process the table but it is showing this error:

There is no data in any tables.

Re: . Error: 'The start date or end date in Calendar function can not be blank value.

lbendlin — Fri, 28 Jun 2024 14:04:39 GMT

You may have wanted to mention that the issue is in Tabular Editor. Ask their support team for assistance.