Forum Discussion
Execute a parametric SQL query to get data filtered based on the values of a column or measure
Hi everyone! Is it possible to execute a parametric SQL query on a data source to retrieve data filtered based on the values of a column, measure, or some specific values? For example, I have a ...
Dear lbendlin ,
Thanks for your information.
It is sad, because DAX and Power query have some limitations, or maybe I need to learn more about them.
Currently, I have a Pro user license. Please let me know is there any better/faster way to get support, e.g., directly from Power BI support team?
Thanks and best regards,
Farhad
Power BI is not designed for what you want to accomplish. It has no memory, no mutable variables and has no concept of data write-back. What you are looking for is something that supports the full information cycle. Maybe that is something you would have to develop yourself.