Forum Discussion
SSAS Connection and url filters
Hey,
In a report i was using URL filters and it was working great, so i tried implementing it on a report using SSAS connection. And somehow it doesnt work. i've tried multiple filters to get it right, but non work.. Example:
?filter=Booking/Booking0x20ID eq '7793'
?filter=Booking/Booking_x0020_ID eq '7793'
?filter=Booking/Booking ID eq '7793'
?filter=Booking ID eq '7793'
?filter=Booking_x0020_ID eq '7793'
?filter=Booking0x20ID eq '7793'
all doesnt work. My Power BI looks like:
7 Replies
Anonymous
Is Booking ID field type text? If not remove the colon from the value.
Example:
?filter=Booking/Booking_x0020_ID eq 7793
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#field-types
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Anonymous
https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/
As per this link, Field type has to be a string. Maybe SSAS live source not yet supported the whole number in the URL filter feature.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
HI Anonymous
I have tested on my side, it works well.
This is my url
?filter=Table/ID eq 7793
Result:
and i think this should work in your report:
?filter=Booking/Booking ID eq 7793
and I wonder what is the data type of [Booking ID]?
Regards,
Lin
I tried that too, i figured out the data type is registered as a BigInt in SSAS. I used this with a string and that works:
?filter=Portfolio%2FPortfolio_x0020_Code%20eq%20%27CODE%27
But that ofcourse is a string and not an BigInt..
Also i do see this when i use:
?filter=Booking%2FBooking_x0020_ID%20eq%207793
