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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-haibl-msft
Employee
Employee

@Anonymous

 

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
Anonymous
Not applicable

Thanks Vicky, this fixed the problem.

 

Regards,

Jure

Vicky_Song
Impactful Individual
Impactful Individual

 
v-haibl-msft
Employee
Employee

@Anonymous

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.