Forum Discussion
Pulling in data from SQL server based on a search combo box
Hello,
I need help setting up a dashboard where the user or several users can get data based on a search of the client name and date of birth. The database has about 75 million rows and it would be slow to connect to it and search.
Any ideas on how to make the search faster over the network? I was thinking of using parameter but my query using advanced editor is not working for some reason.
Is it possible to bring in data into powerbi for only 1 client at a time using SQL? Would it be faster than querying the entire database and bringing in data via the SQL connection?
Thank you.
rajaa2525 , if this is a direct query connection
Create a parameter page first
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
make sure you have separate client and date tables
New means to access display pages - Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4
1 Reply
- amitchandak
Super User
rajaa2525 , if this is a direct query connection
Create a parameter page first
Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
make sure you have separate client and date tables
New means to access display pages - Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4