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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Bug - Smart Narrative Confusion When Connecting Dataset Using DirectQuery

I'm using a model -- connect power bi dataset with DirectQuery mode. When I use the following smart narrative statement "maximum date MMM" in this model, it returns "APR". I did not apply any filters. The Desktop version that I'm using is 2.116.884.0 64-bit (April 2023).

 

winnerzlx_0-1686722591895.png

 

The data I used in the original dataset are as follows.

 

Date_YYYYDate_MMM
2021APR
2021AUG
2021DEC
2021FEB
2021JAN
2021JUL
2021JUN
2021MAR
2021MAY
2021NOV
2021OCT
2021SEP
2022APR
2022FEB
2022JAN
2022MAR
2022MAY
Status: Investigating
Comments
Anonymous
Not applicable

Hi @Anonymous ,

 

Power BI has released the latest version of Power BI Desktop, the June release.
Please update to the latest version to see if the problem persists, and if so we will do further investigation for you.

 

Best regards.
Community Support Team_Caitlyn