Forum Discussion
. Error: 'The start date or end date in Calendar function can not be blank value.
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.
3 Replies
- lbendlin
Super User
You are using CALENDAR() in your DAX code, and one of the date boundaries is incorrect. Check your code.
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.- lbendlin
You may have wanted to mention that the issue is in Tabular Editor. Ask their support team for assistance.
