Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
"re-configured" - do you mean upgraded to 170.8 ?
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.
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.
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.
Did it work before? Which gateway version are you using?