Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Dasher123
Frequent Visitor

Paginated Report Gateway Connection update using REST API

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.

Dasher123_0-1648638619995.png

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?

7 REPLIES 7
Sukhjeevan
Regular Visitor

Any updates or and fix for this issue

SamitDesai
Frequent Visitor

Any upadte on this ?

or any workaround?

maordahari2
New Member

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

MelanieL
New Member

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

Dasher123
Frequent Visitor

No one knows any solution to this?

Hi @Dasher123 ,

 

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

RicoZhou_0-1649054529540.png

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.

Hi @v-rzhou-msft,

 

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?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.