cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Issue with FILTER function in DirectQuery mode - NOT WORKING

Hi,

 

I created a report that uses a DirecQuery connection to Azure SQL Database. I first created it on my laptop in the latest version of PBI Dekstop (downloaded and installed on 15/06/2017) where it works fine. I published it to the PBI Service and also works fine. Then, I opened that same file on my desktop (it's more powerful, easier to work on and is connected to a different network with access to internal systems) running the same version of PBI Desktop and Windows 7 as on my laptop and the calculation where I use the FILTER function doesn't work anymore. 

 

If I remove this calculation from the chart it works fine. So, I don't get why the exact same file, on the same version of PBI Desktop works in one place and not the other.

 

Can you please contact me to find the solution to this problem. I already reinstalled PBI Desktop and checked that all connections to the source system work as expected. I both tried the file that I had on the other PC sent via email and the file downloaded from the Service.

 

Many thanks,

Jure

 

~~~~~~~~~~~~~~~~~~~~~~~~~

 

Feedback Type:
Frown (Error)

Timestamp:
2017-06-16T06:15:59.1708816Z

Local Time:
2017-06-16T08:15:59.1708816+02:00

Product Version:
2.47.4766.542 (PBIDesktop) (x64)

Release:
June, 2017

IE Version:
11.0.9600.18617

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: True.

Peak Working Set:
512 MB

Private Memory:
426 MB

Peak Virtual Memory:
3.7 GB

Error Message:
MdxScript(Model) (16, 4) Function 'FILTER' is not supported in this context in DirectQuery mode.

User ID:
623f4b96-c52f-42e8-9b17-2a62ac81ca0f

Session ID:
d372cc13-644a-4fcc-99c7-bd12cd265f4e

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\...

Performance Trace Logs:
C:\Users\...

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer

Disabled Preview Features:
PBI_Snowflake
PBI_SpanishLinguisticsEnabled
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Fri Jun 16 2017 08:03:27 GMT+0200 (Romance Daylight Time)

Error Code:
QueryUserError

OData Error Message:
Failed to execute the DAX query.

DPI Scale:
100%

Supported Services:
Power BI

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Issue with FILTER function in DirectQuery mode - NOT WORKING

@jurejaklic

 

Please check following option in your second machine, and enable it if it is disabled there. Restart Power BI Desktop and have a try again.

 

Filter is not working in Direct query mode_1.jpg

 

Best Regards,

Herbert

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Issue with FILTER function in DirectQuery mode - NOT WORKING

@jurejaklic

 

Please check following option in your second machine, and enable it if it is disabled there. Restart Power BI Desktop and have a try again.

 

Filter is not working in Direct query mode_1.jpg

 

Best Regards,

Herbert

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

Re: Issue with FILTER function in DirectQuery mode - NOT WORKING - Status changed to: Needs Info

 
Highlighted
Frequent Visitor

Re: Issue with FILTER function in DirectQuery mode - NOT WORKING

Thanks Vicky, this fixed the problem.

 

Regards,

Jure

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors