Forum Discussion
Solved
Paginated report - get data from API
Is it possible to use web apis to get data into paginated reports? Something that was possible in SSRS reports using XML queries. Thanks
Not from there, but to there. 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.
Word is that you create a Power BI Dataset against that web API, and then consume that dataset in Report Builder.