URL filtering in report not working

[VidarRadiv]

Hi all

Putting my trust in all the experienced pple here, not able to solve this by myself, other posts, youtube vids etc.

Problem: Have a test report published at "My Workspace" with 3 rows total. 1 row for author_id = 10, and 2 rows with author_id 6746 (see below)

In short, this URL with filter still returns all 3 rows:  [URL report address]/ReportSection?filter=A/Author_ID eq 10

When pasting the above URL into the "app.powerbi.com/groups/me, this is how the string looks: "...ReportSection?filter=A%2FAuthor_ID%20eq%2010"

This is the setup in PBI Desktop for the field Author_id, Integer datatype:

[Anonymous]

Hi @VidarRadiv 

Please check the data type of author_id field, is the data type of the field whole number?

After testing, if the data type is text, when you use the ?filter=A/Author_ID eq 10, it will return all rows, you need to modify the expression to ?filter=A/Author_ID eq ‘10‘. it the data type of the field is number, after using  

?filter=A/Author_ID eq 10, it will return related result.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VidarRadiv]

Hi, and thanks for the input.
In my initial post, I wrote that Author_ID holds Integer data type. (I have just for the sake of it also tried ...eq '10'. Still all 3 rows are returned where 1 is expected)

[Anonymous · Accepted solution]

Hi @VidarRadiv 

1.Please check whether your column name contains spaces or table names contain spaces, there are restrictions on the expression of spaces in the URL, if so, it is best to remove the spaces.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-...

2.Check if the Author_ID in your visual is a field from table A, does it come from another table?

3.Try changing browsers before typing.

4.Try replacing the column name with AuthorID , the symbol "_" may not be recognized in the URL.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VidarRadiv]

Thx 4 yr help :-). I tried switching from the "List A" to "List B". Then the URL-filtering worked. I consider therefore yr suggestions as the solution to this problem

[VidarRadiv]

Hi Yolo, and again thanks for your help. I started from scratch now, in order to eliminate any conversion/naming errors:

I only retrieve data from one table, "A". 

Procedure:

1. Get Data: Sharepoint List

2. No renaming to Report of Sharepoint List column names ("AuthorId" is the column name given by SP)

3. No adjustment of data type (using the "original Sharepoint type for "AuthorId")

Trying to paste into the web browser (Microsoft Edge), both of the following:

[URL to report]...ReportSection?filter=A/AuthorId eq 10

[URL to report]...ReportSection?filter=A/AuthorId eq '10'

Still all 3 rows are returned on the Report in My Workspace

Pasting same two URLs into the Chrome web browser, same result....