Query Parameters on DataSets based on Oracle DataSources

[MarkTarpey]

Hi 

I am creating a DataSet using an Oracle DataSource and I'm trying to add Query Parameters. 

The substitution syntax is different

WHERE MyField = @MyParam in a SQL Server query

becomes

WHERE MyField = &MyParam in an Oracle query.

MyField one is NUMBER(4)

MyParam is an Integer

I've tried amending the syntax of the Query to use the Oracle format but can't get it to work properly - I keep getting Invalid Number errors.

Does anyone have any experience of this, or any examples of how they have used Query Parameters with Oracle datasources?

Thanks,

Mark

[theov]

This will help on thi subject. For creating a parameter from Orcale source or using a parameter in Orcale query.

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

[MarkTarpey · Accepted solution]

Hi,

thanks for the reply. I worked out the problem 

when using query parameters for an Oracle query in Paginated Reports 

Where Field1 = :Parameter

i.e. use ':' where SQL Server query would use '@'

[DataInsights]

@MarkTarpey,

The post below may be helpful:

https://community.powerbi.com/t5/Desktop/Passing-user-selected-values-to-a-query-to-another-query/m-...