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