Data Import depends on the user

can you clarify what you mean about how the imported data can be changed easily? from the sounds of it you need to set up parameters

this video and blog goes through the steps of how to set up parameters to pass to sql

https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI

https://blog.crossjoin.co.uk/2016/12/11/passing-parameters-to-sql-queries-with-value-nativequery-in-power-query-and-power-bi/

maybe this can help as i think parameters will be what you need to do.

crln-blue 

You can create a Parameter that allows you to filter the data before importing to Power Bi desktop. 
Please refer to the steps: https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.