topic Re: Paginated Report Gateway Connection update using REST API in Developer

Paginated Report Gateway Connection update using REST API

Dasher123 — Wed, 30 Mar 2022 11:20:28 GMT

Is there a way to update Gateway Connection datasource for paginated report using Power BI REST API?
I can do this manually when logged into Power BI platform(screenshot below), but if I have over 100 reports and I need to change gateway connection data source for each report it will take a long time and can introduce human error.

For Dashboard datasets I can do this using this REST API call: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/bind-to-gateway-in-group

Is there something similar that can be used for Paginated reports?

Re: Paginated Report Gateway Connection update using REST API

Dasher123 — Fri, 01 Apr 2022 11:21:42 GMT

No one knows any solution to this?

Re: Paginated Report Gateway Connection update using REST API

Anonymous — Mon, 04 Apr 2022 06:47:29 GMT

Hi @Dasher123 ,

Datasets - Bind To Gateway In Group API needs datasetID in REST API URL Parameter.

Since paginated reports (RDL) don't have a dataset, there is not dataset ID value in paginated reports.

As far as I know, Power BI doesn't support us to update Gateway Connection datasource for paginated report by Power BI REST API.

Best Regards,
Rico Zhou

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

Re: Paginated Report Gateway Connection update using REST API

Dasher123 — Mon, 04 Apr 2022 08:29:38 GMT

Hi @Anonymous,

Thank you for the reply.

If there isn't any REST API for paginated reports what is the best way to update Gateway if I have over 100 reports?
Are there any PowerShell scripts?
Are there plans to have REST API for this functionality in the future?

Re: Paginated Report Gateway Connection update using REST API

MelanieL — Wed, 31 Aug 2022 12:13:47 GMT

I have the same requirement - cannot find any information for how to do this - but surely it should be possible?

Re: Paginated Report Gateway Connection update using REST API

Anonymous — Thu, 29 Sep 2022 08:35:15 GMT

hi i spoke with Microsoft regarding this issue last month they said that they don't have the api that doing binding between paginated report and power bi gateway

Re: Paginated Report Gateway Connection update using REST API

Anonymous — Thu, 21 Sep 2023 04:38:26 GMT

Any upadte on this ?

or any workaround?

Re: Paginated Report Gateway Connection update using REST API

Sukhjeevan — Tue, 26 Mar 2024 05:09:07 GMT

Any updates or and fix for this issue