0

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?

Improve this question
3
  • You will need to look at using DirectQuery Commented Jul 12, 2024 at 1:36
  • Paginated reports would be the way to go for this maybe? Commented Jul 12, 2024 at 6:57
  • @SamNseir The query im using is a recursive query that uses a WITH clause. DirectQuery does not allow WITH clauses Commented Jul 12, 2024 at 18:34
Related questions
1
Power BI report sharing and import mode
1
What is the way to flush (reset) data in the Power BI report [dataset] (specifically for an incremental refresh based report)?
1
Power Bi - Autorefresh the PowerBi report with import Query
Load 4 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.