Forum Discussion
How to load data based on parameter change?
For example,
Data: I've two tables one with list of users, second with usage value and user.
Use case:
- Dropdown to select one user from the list (data from Table 1)
- Graph that shows usage for that user (data from Table 2)
Problem:
Since Table 2 is too large to fit in the memory, I can only query that table for a specific user. So, is there a way I can achieve this?
Thank you.
PS - I'm very new to PowerBI 😟
4 Replies
Anonymous , Are you looking to first select a value in the slicer and then show the data on page ?
If yes, I have created a video on that, see if that can help https://www.youtube.com/watch?v=F3qMwQtWjvo
if not, can you provide more details on what you need.
Thanks for responding @amitchandak , but that video isn't related. @Jihwan_Kim @selimovd
Let me rephrase my problem.
I want to query the database based on the user_name and populate the graph. I want to query each time the user has changed their selected user from the dropdown (slicer).
Hi Anonymous ,
Your problem is related to the storage mode of the data.
If your data source supports the Direct Query mode, there is no need to import the data into the data model. When you use the slicer, the query will be sent to the data source and the calculation result will be returned.Or you can consider using dynamic M parameters.
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
