Forum Discussion
URL filtering in report not working
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:
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.
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.
5 Replies
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.
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)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.
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.
