Data Import depends on the user

[crln-blue]

Hello!

I'm fairly new to PowerBI and still learning the ropes.

I have a report where (non pro user) my client wants the current data to be displayed. In order to save time on importing data from SQL Server, what I did is get the data from the last 2 months up to the current. I put a SQL statement on the data import process:

Now, my clients wants to suddenly look at the past year's data. Is there an option where importing data can be changed easily? The only solution that I can think of is to load all the data and then, filter the needed data for the display. However, loading all the data will require a lot of time and will make the PBIX file larger. We're not using Pro so we can't do incremental refresh. 

Any help is appreciated. Thank you.

[vanessafvg · Accepted solution]

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-...

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

[V-pazhen-msft · Accepted solution]

@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.

[vanessafvg · Accepted solution]

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-...

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