- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
SSRS reports in PBI premium - API Call to download CSV or PDF reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-14-2019 08:22 PM
We currently use Power BI premium (PBIE for embedding into applications and PBIS for Self service). We also use an on-premise SSRS 2017 server for generating paginated reports (CSV and PDF) by calling the API from the application. If I move the .rdl file to PBIS, how do I call the report to download the CSV or PDF into my application.
GET https://api.powerbi.com/v1.0/myorg/reports/{reportKey}
This does not allow me to pass the rs:Format=CSV parameter like in SSRS 2017. Any thoughts as to how I can achieve this?
Solved! Go to Solution.
Accepted Solutions
Re: SSRS reports in PBI premium - API Call to download CSV or PDF reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-21-2019 09:59 AM
hi sanathv,
API support for exporting Paginated Reports in PowerBI.com service is planned but not yet implemented. It is on our roadmap but team will not be getting to it for the next few months.
Thanks,
Rohit
All Replies
Re: SSRS reports in PBI premium - API Call to download CSV or PDF reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-16-2019 01:19 AM
Hi @sananthv
Do you mean:
You create some datasets and reports in power bi service,
then embed these contents from power bi service into your applications.
next you get data from your applications and create paginated reports in on-premise SSRS 2017 server.
finally you want to put paginated reports in power bi service and then embed paginated reports to your application.
right?
You could read these articles to get some ideas:
https://docs.microsoft.com/en-us/power-bi/paginated-reports-embedded-data-source
https://docs.microsoft.com/en-us/power-bi/paginated-reports-parameters
Best Regards
maggie
Re: SSRS reports in PBI premium - API Call to download CSV or PDF reports
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-17-2019 04:03 PM - edited 01-17-2019 04:05 PM
Thank you for the response. I think I did not articulate the issue well. I have already created the paginated report and published to the service (with the intension of shutting down the onpremise SSRS server eventually). I can render the report in my application and the user needs to manually save it as a Word/Excel/PDF etc file. This is working fine.
This is not my requirement. My requirement is to get the report directly in Word/Excel/PDF etc formats. Https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getreports does not have any documentation on how to pass parameters to get the report in Word/Excel/PDF etc directly from the paginated report.
Re: SSRS reports in PBI premium - API Call to download CSV or PDF reports
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-21-2019 09:59 AM
hi sanathv,
API support for exporting Paginated Reports in PowerBI.com service is planned but not yet implemented. It is on our roadmap but team will not be getting to it for the next few months.
Thanks,
Rohit