Forum Discussion

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
2 years ago

Native query on OLEDB source with parameteres doesn't work

I have a native query with a parameterised where caluse like this... WHERE CALDATE > @datefrom AND CLDATE < @dateto I try to query it  let Source = OleDb.DataSource("provider=IBMDASQL.DataS...
Need Help
AnalyticsWizard's avatar
AnalyticsWizard
Icon for Solution Supplier rankSolution Supplier
2 years ago

The issue you’re encountering might be due to the way OLE DB handles parameters in native queries. In some cases, OLE DB might not support parameterized queries in the same way as other data sources1.

Here are a few potential solutions:

  1. Use Literal Values: If possible, consider replacing the parameters with literal values directly in the query. This might not be feasible if the parameters change frequently or are user inputs1.

  2. Use Power Query Parameters: You can create parameters in Power Query and use them in your native query2. However, this might not work if you need to pass the parameters dynamically at runtime1.

  3. Check Query Syntax: Ensure that the syntax of your query is correct and that the parameters are properly defined and used1.

  4. Consider Other Data Sources: If OLE DB continues to cause issues, you might want to consider using a different data source that better supports parameterized queries1.

Remember, these are just a few potential solutions. The exact solution might vary depending on the specifics of your setup1.