Forum Discussion
Post PatronData Import depends on the user
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.
- 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.
2 Replies
- vanessafvg
Community Champion
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.