Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Date.IsInCurrentWeek() function causes data refresh to partially fail

Submitted by Anonymous on ‎04-25-2023 08:55 AM

I have a calculated column using the Date.IsInCurrentWeek() function. This works with all my visuals in desktop. I can publish the dashboard and my data appears correctly. Once the data is refreshed, any visual using this field no longer returns any data. I can re-publish the dashboard to temporarily get these visuals for work again, but they will once again return no data after a data refresh. As soon as this column is no longer utilized in the visuals I no longer have this issue.

 

Thanks,

Nick

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎04-26-2023 12:37 AM

Hi @Anonymous ,

 

Based on your descriptions, You may try open it in Power BI desktop, click the refresh button, save it, and the re-publish. 

 

Hope it helps!

 

Best regards.
Community Support Team_ Caitlyn

Anonymous
Not applicable
‎04-26-2023 06:05 AM

Hi @Anonymous ,

 

Unfortunately although the refresh in desktop seems to work consistently, re-publishing only temporarily fixes the issue until the data is refreshed next online, and then the visuals using the column calculated using this formula stop working again.  I did notice that this also happens with the Date.IsInPreviousWeek() when I was looking into work arounds.

 

Thanks,

Nick

Idea Statuses