Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Visuals with DAX date based filters cannot load the data in Power BI Service

Just this morning, some reports that have been using DAX for date based filters suddenly cannot display the visual.  These visuals do work in PBI Desktop.  Once published to the serivce, they work for less than a minute.  Below is an example of what happens when the visual has this filter: 

IsCurrentQuarter = IF(QUARTER(Date[Date]) = QUARTER(TODAY()) && YEAR(Date[Date])=YEAR(TODAY()),"Y","N" )

melany_0-1676407089654.png

Was there an update to PBI Serice that is rendering date-based DAX filters unusable?

 

Status: Investigating
Comments
Anonymous
Not applicable

Hi  @melany ,

 

Does the same problem exist in Power BI Desktop?
Have these reports worked properly in the past?
Please provide us with your PowerBI Service version information.

 

Best Regards,
Community Support Team _ Caitlyn

 

melany
Advocate I

Hi @Anonymous 

In Power BI Desktop, there is no problem.
Yes, the reports have worked properly in the past.
Service version13.0.20105.44 .

Thanks
Melany