Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
1 year ago
Solved

Why does CALENDAR function throw 'start or end date cannot be blank' only in Power BI Desktop with I

Why does CALENDAR function throw 'start or end date cannot be blank' only in Power BI Desktop with Incremental Refresh?   Hello Power BI Community, I'm implementing Incremental Refresh for my repo...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    1. Always use UTC. Always.  If you want, use COALESCE to substitute for BLANK()

    2. see 1

    3. see 1

     

    Note that Power BI has no idea what a timezone is. It's up to the Power BI service to negotiate that with the user's browser.

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi manoj_0911 ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.