Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Paginated Report not working

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
Need Help
  • rpatkar's avatar
    rpatkar
    6 years ago

    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

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous moved to Power BI Service forum post.

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      v-yingjl Thanks it is mapped.

      • rpatkar's avatar
        rpatkar
        Icon for Power BI Team rankPower BI Team
        6 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    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