cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

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

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

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 @v-xiaoyan-msft 

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

Thanks
Melany