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 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.