The JSON does not represent a valid data source

[gashupl]

I have a [dbo].[Payment] table in my Azure SQL database. I've configured SQL Connection and it works correctly when I'm using it from Canvas App. However when I've tried the following PAC CLI command to generate PaymentService and PaymentModel, I'm getting error every time:

pac code add-data-source -a "shared_sql" -c "12361d4d5861472581aa422f582ed210" -t "[dbo].[Payment]" -d "my-sql-server.database.windows.net,my-db-name"

Error: An unexpected error occurred: Error processing file 'C:\Users\PiotrGaszewski\Desktop\CodeAppPoc\codeappsdemo\CodeAppPoc.power\schemas\sql\Payment.Schema.json': The JSON does not represent a valid data source.

The mentioned Payment.Schema.json is automatically generated by PAC CLI.
This is happening for every table in my database. Any idea what could be wrong?

[sebastiandiaz21]

I'm getting the same error when adding Tabular data from Sharepoint Lists

[saussam18]

Can you open that json (Payment.Schema.json) and see if it contains valid json? Also what version are you using for PAC-CLI?

[gashupl]

PAC CLI version is Microsoft.PowerApps.CLI.1.50.1
Generated JSON was successfully validated on https://jsonlint.com/ site.

Today I've tried to replicate this behavior using pac code add-data-source command but right now I'm getting "Invalid URI format" error.
Nothing has changed in my database and connector configuration.
pac connection list command shows my connection with "connected" status.

[davidperl99]

PAC CLI version is Microsoft.PowerApps.CLI.1.50.1 Generated JSON was successfully validated on https://jsonlint.com/ site.

Today I've tried to replicate this behavior using pac code add-data-source command but right now I'm getting "Invalid URI format" error. Nothing has changed in my database and connector configuration. pac connection list command shows my connection with "connected" status.

It took me the whole day to find a fix, but you should add "region": "prod", in power.config.json

[gashupl]

@davidperl99 Thanks for the tip! Using "region": "prod" I was able to add data source again. The reported issue with invalid JSON generation also magically disappear.