Forum Discussion
Solved
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 ...
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.
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 Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.