Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago
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
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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