Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
11 months ago
Solved

API calls during report use

Hi all,   Bit of a general query here. I'm currently using an ETL software (Alteryx) to download data from an API for one of our services. This requires the user to select various parameters such a...
Need Help
Tutorial Requests
  • sergej_og's avatar
    sergej_og
    11 months ago

    Hey EpicTriffid ,
    in general using DQ and selecting (=applying) filter would send a new query to the source.
    To avoid this load of queries you can enable the "Apply all slicers"-Button on the UI.


    But DQ is still not that efficient in terms of waiting time.
    Using API in this way might be a big pain. API performance?

    Regards

Yashwant_DSP's avatar
Yashwant_DSP
New Member
11 months ago

Build an Azure Function / API gateway that accepts filters, calls upstream API, transforms results and writes to Azure SQL / Synapse. Connect Power BI to that SQL using DirectQuery so slicers become SQL queries and only return needed rows. Add caching/TTL and pagination in the proxy to protect the API. (Best UX and governance for large datasets.)