On-premises Data Gateway - There was an error contacting an underlying data source

[TahmidBari]

Hi PBI Team,

Please be advised that I am using the On-premises Data Gateway (v3000.138.3) and the PBI Paginated Report Builder (v15.7.1799.16). And I used Report Builder to migrate the SSRS reports publised into PBI Services. However, when I run the reports, I receive the following error 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.

Could you please let me know if I need to update the On-premises Data Gateway and PBI Paginated Report Builder to the most recent version? Thanks.

https://www.sqlshack.com/setting-up-power-bi-data-gateway/

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-app

[TahmidBari]

Hi @lbendlin 
Yes, it was working previously, however after I re-configured the data gateway, it stopped operating.

I'm using the On-premises data gateway (standard mode v3000.170.8). Thanks.

[lbendlin]

"re-configured"  - do you mean upgraded to 170.8 ?

[TahmidBari]

Hi @lbendlin 

That's right. I removed the data gateway from PBI services and then upgraded it to 170.8. Unfortunately, I can no longer run those reports from PBI services. Thank you in advance for your advice.

[lbendlin · Accepted solution]

I removed the data gateway from PBI services 

Oh.  You shouldn't do that. It will result in a new gateway ID.  

You will have to re-attach all your datasets to the new gateway and its new connections.

[TahmidBari]

Hi @lbendlin 

Thank you for your reply. Yes, that's correct. I'll map the data gateway source to all of the reports I've published on power bi services. Thank you for your assistance.

[lbendlin]

Did it work before?  Which gateway version are you using?