Workspaces in premium capacity cannot refresh

[willharris24]

Hi - help needed...  

We have a number of reports which connect to/from a Azure SQL database in our Azure environment

When we move the workspace that they are in to our Premium capacity, the reports are not able to refresh.

If we move the workspace back to shared capacity, the reports work fine again.

any ideas?

---

error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.);A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. The exception was raised by the IDbConnection interface.
Please try again later or contact support. If you contact support, please provide these details.
Show technical details

<message previously posted to wrong board>

[v-juanli-msft]

Hi @willharris24

Please check the dataset settings

You could create a support ticket so you can get a quick and efficient support.

https://powerbi.microsoft.com/en-us/support/

Best Regards

Maggie