Understanding why export paginated report to file is failing

[Suryakant_99]

Hello Experts,

I'm trying to understand the paginated report API endpoint why it's not returning actual message why the process is failed.

I have a set of paginated reports that I am exporting in our API layer via the following documentation

https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report

I have all of them working via this method, but on the initial setup it is hard to understand sometimes when polling for the Export Status, if it fails, why in fact it failed. I am using the following method to poll for the status

var httpMessage = await Client.Reports.GetExportToFileStatusInGroupWithHttpMessagesAsync(groupId, reportId, exportId);

I see the body of this i the export Status but all that tells me is if it succeeded or failed. Is there a way to tell why it is failed anywhere in the API or PowerBI istelf?

Thanks 

SK

[Suryakant_99 · Accepted solution]

I agree with you that we don't receive any error message, although the paginated report was failed.

If you try to debug the paginated report API methods then also it won't give you any exception or error in the paginated model property, but we can do one thing that we can use postman to call that paginated report api endpoint (the endpoint url present inside paginated report mode which you will get at the time of debugging)

In postman, you will get exact error message, and it will help you quickly find the root cause why the paginated report api failed.

[GilbertQ]

Hi @Suryakant_99 

As far as I can see, there's currently no way to get the error for the failed report currently. I would suggest logging a support ticket to get more details.