Pulling in data from SQL server based on a search combo box

[rajaa2525]

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.

[amitchandak · Accepted solution]

@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