Paginated Report not working

[Anonymous]

Hi All

Since PBI doesn't send report as email, i opted for paginated report. The below steps are what i followed

1) Downloaded Power BI Report builder.

2) Added Oracle datasource and tested Successfully.

3) Have a SQL Query that worked in TOAD and in the report builder. Report executed successfully.

4) Save the .rdl file locally.

5) Went to PBI Service and navigated to the workspace i created-->getdata-->file-->and the report was loaded.

Issue

When i clicked on the report i am getting the following message

Unable to render paginated report

There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid. Please try again later or contact support. If you contact support, please provide these details.Show technical details Get help

Trouble Shooting : Navigated to Manage Gateways  and checked the connection , it was successful, but sill not able to get to the report.

Please advice.

Thanks

[MuditMittal]

Unable to render paginated report. There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid. If you contact support, please provide these details.

Do I need to define the data source settings everytime I upload the new report. Is this can be automated or defined in RDL file itself to use the correct data source along with gateway. Thanks

[v-yingjl]

Hi @Anonymous ,

Please check the setting of this dataset whether it has been mapped to this gateway.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yingjl Thanks it is mapped.

[rpatkar · Accepted solution]

hi bkan,

If you are still having this issue on running RDL report then please use the "Copy Details" from the error dialog and provide the details. This specific error message is associated with not setting the correct Gateway setting in the report's settings page. If set correctly, the report will either render or provide another error message if failing to render.

Thanks,

Rohit

[parry2k]

@Anonymous moved to Power BI Service forum post.