cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mittalpatel130
Helper II
Helper II

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.

View solution in original post

lbendlin
Super User III
Super User III

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors