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!

0

Reports unable to refresh when workspace moved to premium capacity

Hi

 

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

 

 

Status: Delivered
Comments
v-yuezhe-msft
Employee

@willharris24,

Are you able to manually refresh the dataset in Power  BI Service? Have you set special firewall rule for the Azure SQL database? 

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info
 
willharris24
Advocate I

Hi

 

Azure DB was set to allow connections from Azure services

And the datasets were Direct connections to the database

And the reports all worked correctly as soon as the Workspace was moved back into shared capacity, and then fail when moved back to premium.

 

Service started working again now - we haven't changed anything.

 

...

 

 

v-yuezhe-msft
Employee
Status changed to: Delivered