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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mittalpatel130
Helper III
Helper III

Call REST API on the fly, pass information from Power BI Visualization in the request

Hello,

 

There is a need to implement Power BI solution in a complex integration project. Here is the scenario and question - 

PBI.png

 

  1. Data source - NoSQL, with huge data size nearly 1TB. 
  2. Use REST API to search through this dataset. API works excellent to perform wild text search on whole dataset. 
  3. Plan is to use this All Text Seach REST API in Power BI to search and display results in table.
  4. Added custom visual 'Text Search' and a Table visual for search results. 

Questions

  1. Can I pass 'string' from Text Search  visual as a request parameter to REST API, to get the results on the fly for end-users? and display results in the table below. 
  2. Any type of customized connector or visual we can use to fullfil this requirement in Power BI? 

Other thoughts 

  1. There is no point to bring 1TB of data to Power BI to perform this search internally and not using the API. 
  2. There is ODBC connection available with DirectQuery capabilities, but here also we need to configure ODBC which ultimately creates a duplicate of dataset and occupies a lot of space on the on-premise server.

Any suggestions?

 

Thank you.

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @mittalpatel130 ,

  1. No, before you use visual to search values in your dataset, all values have been in the underlying data, visual paremeters cannot be passed to api. You can combine parameter query and api in power query first to filter your needed values. Refer these blogs:
  2. ODBC is an alternative choice to achieve this. You can take a look at following links about use custom data connector to achieve odbc directquery. In addition, no data is imported or copied into Power BI Desktop under Direct query mode, all DirectQuery requests are sent to the source database, it will nor create a duplicate of dataset.

 

Best Regards,
Yingjie Li

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

View solution in original post

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @mittalpatel130 ,

  1. No, before you use visual to search values in your dataset, all values have been in the underlying data, visual paremeters cannot be passed to api. You can combine parameter query and api in power query first to filter your needed values. Refer these blogs:
  2. ODBC is an alternative choice to achieve this. You can take a look at following links about use custom data connector to achieve odbc directquery. In addition, no data is imported or copied into Power BI Desktop under Direct query mode, all DirectQuery requests are sent to the source database, it will nor create a duplicate of dataset.

 

Best Regards,
Yingjie Li

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

lbendlin
Super User
Super User

ODBC Direct Query sounds like your only option.  Why do you think that creates a duplicate dataset?

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!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.