calling API from .RDL file

[Kfabric]

How to call external API from paginated report and get data read from output of that API

[v-rongtiep-msft · Accepted solution]

Hi @Kfabric ,

I have found a similar post, please refer to.

Solved: Paginated report - get data from API - Microsoft Fabric Community

You use Power BI Desktop to declare the data source connections. Then you publish that pbix to the service where it becomes a dataset.  Then you can set up the scheduled refresh (if needed) and you can consume the dataset from the rdl.

Reports - Get Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Interactive API calls from Power BI report | by Riccardo Perico | Rik in a Data Journey | Medium

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.