Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I use direct query within Power BI and WEEKNUM doesn´t work because Calculated column dax formrmula doesn´t support WEEKNUM in direct query. How can I calculate it within direct Query?
I have column with dates and I need to add column with week number.
HI,
Any workaround to use WeekNum in direct query?
No news? Have the same problem
I reproduced same issue as yours, my power bi desktop version is 2.36.4434.381. Even I enable "unrestricted measures" in DirectQuery Option, I still get "not supported" error when adding a calculated column to get the week number from SQL table date column.
I suggest you use DATEPART() get the week number on T-SQL query level.
Regards,
Hi @v-sihou-msft how did you get on with finding a solution to this? I have allowed the unrestricted measures but still cannot get the WEEKNUM working on Direct Query mode.
Cheers,
ED.
Where can I find T SQL level?
File -> Options and Settings -> Options and check that you have allow unrestricted measure ticked.
Is this safe? I am afraid of incorrect results.
@pstanek I cannot replicate your issue. I have directquery to sql server and can successfully create calc column with WEEKNUM function. Ensure you have latest version of pbi desktop and go to File -> Options and Settings -> Options and check that you have allow unrestricted measure ticked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |