Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

USING PARAMETERS IN NATIVE SQL QUERY

Dear Community, I have the following query. I have a native SQL server query which has a date parameter and I need to be able to automate it from power query. I share the original query that feeds ...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Hello to clarify a little my doubt, so I was putting together the query:

I was occupying the next function in the advanced power query editor replacing [%] with "&Text.From(Origendinamico)&", but when loading the data my brings the base but without values, they could indicate that I am doing wrong.

Your help is appreciated.

Diego

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

I think the inconsistency is in the format of the date, have you tried to place that same date structure that you have stored in the Origendinamico parameter directly in the query? If it doesn't bring you data, you should check the exact format used by the database engine or perform a field conversion to match the values.