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: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. 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