Calendar Week Delegation Failed at Databricks SQL Warehouse

Hello loujiang,

Thank you for the update. I'm glad to hear you've successfully resolved the issue by using a native query to handle the calendar week calculation before query folding kicks in. That's a smart and efficient workaround and it's great that it's working for you now.

Regarding your question: Yes, this appears to be a compatibility issue (or bug) in how Power BI's query folding translates the "Week of Year" transformation to SQL for the Databricks connector, delegating an unsupported week() function instead of the Databricks-compatible weekofyear().

However, there's no specific confirmation yet that this exact week() delegation issue is fixed in upcoming versions. We recommend raising it in the Ideas forum (Fabric Ideas - Microsoft Fabric Community) and upvoting it so the internal team can review and prioritize it for implementation soon.

Thanks again for the resolution update; it'll help others searching for similar issues.

Best regards,
Ganesh Singamshetty