Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to use web apis to get data into paginated reports? Something that was possible in SSRS reports using XML queries.
Thanks
Solved! Go to 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.
@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.
"it" - being the dataset? That's standard Power Query functionality. Where are you stuck?
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.
When I say add Power BI dataset connection it points me to Powerbi service. where do I go from there?
Word is that you create a Power BI Dataset against that web API, and then consume that dataset in Report Builder.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.