I've got a Paginated Report built by one of our staff working locally in published into a premium per user workspace. However I created a new workspace (same Premium Per User) and downloaded the report into PowerBI Report Builder latest version, updated the Azure SQL connection, tested the connection (which passed) ran the report locally (which works correctly) then published the new report to the the new workspace (FAILS) .
Any ideas why I can not change the credentials in workspace for Azure SQL TDS connection string
Here are the background details
Locally
Report builder ver 15.7.1799.16
1. Downloaded report it runs just fine.
2. Test the Datasource - Azure SQL TDS connection - in PowerBI Report Builder - it works
3. Query the Dataset locally - works
4. Created Clean Workspace (Premium Per user)
I'm the workspace admin for this workspace
5. FAIL ON Running Paginated Report [error shown below]
In PowerBI
** The PowerBI UI does not allow for the changing or the expanding of the Data Source Crendentails
1. Workspace Premuim Per User (diamond appears) Per User
2. Open Paginated report -
ERROR
Could not connect to the data source.
There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.
Timestamp: 2022-09-06T04:15:40.693Z
Root activity ID: 92dd9978-6bd9-c8a8-df8a-22dd4097f86e
Session ID: 00001df00e4b444e992d97baf0a85456
Tenant ID: 4a24bbbd-3187-45e5-85d4-91d0cfbe0592
Cluster: https://wabi-us-north-central-redirect.analysis.windows.net/
Report ID: 4625cc14-9281-4e7b-a6c8-1db62485bb2f
ReportViewerVersion: 2022.8.4.2862
Any Ideas how to publish this paginated report and connect?
