Forum Discussion
mittalpatel130
6 years agoHelper 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 -
- Data source - NoSQL, with huge data size nearly 1TB.
- Use REST API to search through this dataset. API works excellent to perform wild text search on whole dataset.
- Plan is to use this All Text Seach REST API in Power BI to search and display results in table.
- Added custom visual 'Text Search' and a Table visual for search results.
Questions
- 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.
- Any type of customized connector or visual we can use to fullfil this requirement in Power BI?
Other thoughts
- There is no point to bring 1TB of data to Power BI to perform this search internally and not using the API.
- 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.
Hi mittalpatel130 ,
- 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:
- 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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- lbendlinSuper User
ODBC Direct Query sounds like your only option. Why do you think that creates a duplicate dataset?
- v-yingjlCommunity Support
Hi mittalpatel130 ,
- 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:
- 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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.