Change Connection String with REST API - Paginated Reports

[AdamMG]

Hi all.
I need to change connections sting in my Paginated Power BI Report.
Previously I just had to send request like here https://learn.microsoft.com/en-us/rest/api/power-bi/reports/update-datasources-in-group#code-try-0
with my payload like this

{
	"updateDetails": [
		{
			"datasourceName": "DataSourceName",
			"connectionDetails": {         
				"server": "ServerName",
				"database": "DataBaseName"      
				}     
		}  
	] 
}

and everything was working.

As you know, Power BI Report Builder got new functionality and now we can connect to SQL (Get data) ->SQL Server database and do some transformation in Power Query.

The problem is, when I try to change connection details through REST API it doesn't work anymore. 
I do get 200 server response, so now errors, but when I try to run report, it's trying to connect to old server and database (not the new one one from payload)

Any idea what is wrong?

[v-achippa · Accepted solution]

Hi @AdamMG,

Thank you for reaching out to Microsoft Fabric Community.

This behavior here is due to recent enhancements in Power BI Report Builder that introduced Power Query based data sources. Currently, the REST API does not support updating connection details for Power Query data sources in Paginated Reports.

I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

Fabric Ideas - Microsoft Fabric Community

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa