Forum Discussion
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.
6 Replies
Word is that you create a Power BI Dataset against that web API, and then consume that dataset in Report Builder.
When I say add Power BI dataset connection it points me to Powerbi service. where do I go from there?
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.
lbendlinBut how do I make it accepting data from web apis?
"it" - being the dataset? That's standard Power Query functionality. Where are you stuck?
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.
