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
AndyS
New Member

Embedded report filter not working on integer fields?

I am working with embedded PBI reports. If I create the following filter on an nvarchar column it works as expected:

 

?reportId=<Report GUID>&$filter=Record/Title%20eq%20'My test title'

 

However if I try to filter on a number column (tested on smallint and bigint columns) with something like:

 

?reportId=<Report GUID>&$filter=Record/ID%20eq%20'1234'

 

I get "This filter can't be used since the corresponding field is invalid". I can create a report-level filter using the ID field and the filters in the filter pane look identical. Is this a bug or is my syntax wrong?

2 REPLIES 2
akagiz
Frequent Visitor

Hi there,

 

maybe you get that exception because of your commata -> ' <- 

Because Int32 columns must not be quoted.  Just try it without those: ?reportId=<Report GUID>&$filter=Record/ID%20eq%201234

 

As referred to this example:

http://services.odata.org/V4/OData/OData.svc/Products?$filter=ID%20eq%20%275%27 -> with quotes

http://services.odata.org/V4/OData/OData.svc/Products?$filter=ID%20eq%205 -> without quotes

 

Greetings

Thanks for your suggestion akagiz. I thought I replied to your post the other day but apparently not.

 

I did try creating the filter without the single quotes around the value as you suggested before posting here but didn't have any success.

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.