API

[Cdeyoung-1998]

Hi PowerBI Experts,

I have a requirement where I need PowerBi to pass user-provided filter values to an API at run-time, have the API receive the parameters, run the calculation, return the data, and then have PowerBi immediately present the results to the user.  We have data that is incredibly complex and can only be returned by our calculation engine.  It is prohibitive to send all of the results to PowerBi cache ahead of schedule, as we would have trillions of rows and a data synchronization nightmare. 

How can we implement the below scenario without using PowerBI cache?

Scenario

1. User Logs in to a PowerBi report

2. User provides values to filters

3. User submits query

4.PowerBI passes the filters to an API

5.API returns the data for the report

6.Powerbi presents the data to the user

[lbendlin]

1. That's not a thing. Users don't log into reports.

3. How? By pressing a button? through a PowerApps visual?

Since your data source is not a Direct Query source your options are limited to a PowerApps visual in Power BI, or R/Python visuals that render the results in some graphical way.