Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Jays
Frequent Visitor

. 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 3
Jays
Frequent Visitor

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. 

 

Jays_0-1719554704973.png

 

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

Jays_1-1719554807077.png
There is no data in any tables.

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

lbendlin
Super User
Super User

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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.