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: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Bug - Smart Narrative Confusion When Connecting Dataset Using DirectQuery

Submitted by Anonymous on ‎06-13-2023 11:12 PM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎06-15-2023 01:47 AM

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

Idea Statuses