Paginated report - get data from API

[Markzolotoy]

Is it possible to use web apis to get data into paginated reports? Something that was possible in SSRS reports using XML queries.

Thanks

[Markzolotoy]

@lbendlin Here is the whole picture. I have a .NET process (API) that generates images on demand. Report places a request: http://computername/..../endpointname. The endpoint can return either a Base64 string or decoded memory stream. Works fine in Browsers. If specify external source for image with expression http://computername/..../endpointname the endpoint gets hit but instead of an image I get red x. That is in the Builder. Published report shows this:

Unable to load image and no technical details available.

[lbendlin]

"it" - being the dataset?  That's standard Power Query functionality.  Where are you stuck?

[Markzolotoy]

@lbendlinBut how do I make it accepting data from web apis?

[lbendlin · Accepted solution]

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.

[Markzolotoy]

When I say add Power BI dataset connection it points me to Powerbi service. where do I go from there?

[lbendlin]

Word is that you create a Power BI Dataset against that web API, and then consume that dataset in Report Builder.