Using Power BI as a front end

[thentangler]

I have a large dataset in a SQL database. I want the user to enter a search string which will then execute an SQL  query to pull relevant data that will then show up as a table in the report. I cant define the query in the source of the power query table since it will take a long time for the report to refresh. 

Is there a way to have Power BI execute the query with the search string as a filter and show the report?

[v-tianyich-msft]

Hi @thentangler ,

Basically, power bi desktop is a software that transforms data. You seem to only be able to filter the data you need to connect to via a SQL statement.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.