Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Using search input in query

Hi all, 

 

we are developing a navigation table for our data warehouse. We have different repositories and each repository can have several thousand datasets. Right now we hard-coded, in the API call, a limit of X results lest loading is extremely slow or leads to a crash, which means we don't get to see all datasets. 

If we then type something in the search window, it simply filters results based on the expression entered, however, this is not piped through to the API call.

 

Is there an easy way I can have access to the contents of that field in my connector logic so that, if its not null or empty, I can use within my call to effectively pass the search criteria down to the API? We had an (optional searchExpression as text) => before the initial call to build the navigation table, but that only shows up once. 

 

A related question would be how to add additional input controls to the navigator panel to change other parameters

 

 

Thanks for any pointers in any of these directions.

 

3 REPLIES 3
lbendlin
Super User
Super User

For the most part Power BI is a one way street.  There are some rudimentary data write-back options in Power Query (via Value.NativeQuery or R scripts) but in the UI you are limited to the PowerApps visual. 

 

This means you cannot realistically use a user input from the UI to impact the query definition in Power Query.

 

One workaround would be to use a Direct Query connection. Doesn't sound like that is an option in your case though.

Anonymous
Not applicable

Maybe it's a matter of terminology but I don't want to write back to the UI, I simply want to get whatever is in the UI (in the particular context of the navigator for a custom connector) and process it as a normal parameter in one of my functions. If I can't use the default search field, then at least one should be able to add additional controls? To deny user input from the UI to adjust a query in this context renders the whole concept nearly useless. 

What you are describing is possible in Direct Query mode only. It is conceptually unsupported in Import mode.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.