Split Function Paginated Report odbc

[Cluster_Ovs_R]

Hi to all, 
I am trying to use a multiple value parameters in a query for a paginated report, with OBDC.
For that i am using the split function like this (is an example)

But this is not good for BD2, either split function is not working --> SQL0440N No authorized routine named "SPLIT" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884

Can you help me?

[v-yangliu-msft]

Hi  @Cluster_Ovs_R ,

This is the related document, you can view this content:

Using String_Split to improve multi-value parameters

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-multi-value-parameter-t...

https://www.youtube.com/watch?v=a4Frj8vG4as

https://community.powerbi.com/t5/Desktop/Paginated-report-with-multi-valued-parameter-not-working/td...

Best Regards,

Liu Yang

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