Forum Discussion
Issues with Fabric Connection REST API and On-Prem Connections
Hi raym85 , Thank you for reaching out to the Microsoft Community Forum.s
Based on the error message you’re receiving (400 - invalid input: the Values field is required) and the payload you shared, the problem likely stems from incorrect formatting of the connectionDetails.parameters section. In Fabric’s REST API, the parameters field typically requires a values property, which should contain an array of parameter values. The API might expect the SQL connection string in a specific format rather than individual server and database parameters.
Fabric REST APIs - Create Connection
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
client is looking to automate the connections that need to be created, the error is mainly a 400 saying invalid input the Values field is required. but no matter how i changed the payload nothing seemed to work
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .