Dynamic data from API while scrolling the table

[shrutivyas06]

Hello All,

We have a custom on-premise REST api which is providing data in chuncks. Now we want below features to be added on the report-

1. To call the API while scrolling the data. In such when the user scolls the page the report will automatically call the API and refersh the visuals accordingly.

2. Filtering- For filtering it is required that the user selects all the filters on the report and when he clicks on a button it will make an API call and API will do the filtering and provide the result to report. With the data returned by API will reflect on the visual.

Is it possible in Power BI?

Thanks in advance.

[shrutivyas06]

Thanks for your reply.

But Direct Query doesn't supproted with Custom API.

Is there any other way for this?

[lbendlin]

You are describing Direct Query mode.  Also, if you look at the queries that are generated to render the visuals you will notice  TOPN(501) a lot - Power BI is already doing that paging against the data source.  In your case you may have to add a middleware broker like a SQL Server stored procedure that hides the fact from Power BI that your API data source is not a Direct Query data source.

For the filters there is an option in the Power BI settings to defer filter application for Direct Query data sources. 

Under Options > Current File > Query Reduction, you can find an option to defer slicer and filter selections until you click "apply."

Lastly it is worth mentioning Paginated Reports - but I'm not sure to what extent these support API data sources.