Forum Discussion

thentangler's avatar
thentangler
Frequent Visitor
2 years ago

Using Power BI as a front end

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?

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.