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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bspiteri001
Frequent Visitor

PBIRS 404 Bad Request when trying to change Connection String from PowerBIReports(id)/DataSources ap

Hi we recently started a server changeover for an SQL which was hosting the PowerBI Report Server. We have migrated the database and the encryption key and everything was a success. However now we wanted to change the connection string to point to the new server. 

 

The reports are connected using the SQL Server connection and they are all in import mode. 

 

Due to the fact that we had lots of reports we thought of automating this process through the use of the API. So what we did is we used the API endpoint identified in the subject and get the result, then we used the result in the value key and pasted it in the body and used the patch. 

However we are getting an HTTP 400 Bad Request message. Can you please advise the reason for this? 

 

Thanks

1 REPLY 1
bspiteri001
Frequent Visitor

All the reports do not use parameter connections and therefore for us, we cannot update through parameter 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.