Forum Discussion
Modify SQL query paramters from Report running on service
Hey mcody ,
what you are looking for is not possible, as Bamak already mentioned. Parameters are not an interactive feature, and for this: using dataflows will be of no help.
Consider using directquery, here data "remains" inside the source system. But be aware, that this means you need a star schema (this means a dwh), if you have to avoid importing all possible data.
Regards,
Tom
Hi Christophe,
Thanks for reply.
Is the functionality you mention only available on Premium? We are on Pro only.
I would like the user to interact with the parameter, pick date, date goes to SQL, data for just that date comes back.
Reuirement is to be able to pick one date form a number of years data, so to import all possible data to service and use a slicer is not practical.
I have done this for paginated report using Report Builder, but these reports cannot be published to service - as far as I know.
I am wondering would Power BI dataflow work for this type of application? I see it looks like it is possible to add parameters to a dataflow.
Have you used these?
Thanks,
Michael
Hey mcody ,
what you are looking for is not possible, as Bamak already mentioned. Parameters are not an interactive feature, and for this: using dataflows will be of no help.
Consider using directquery, here data "remains" inside the source system. But be aware, that this means you need a star schema (this means a dwh), if you have to avoid importing all possible data.
Regards,
Tom