We have some PowerBI reports running against Azure MSSQL databases in Direct Query mode. The reports were working fine, and will still work fine in PowerBI Desktop. However, when uploading to the Web, some of those reports (the more complex ones with multiple widgets) have suddenly started displaying the following error:
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,
orestablished 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.
PBI Desktop works fine with the same datasource settings. Connecting to the database from VS Code using the mssql extension also works.
The only solution we've found is to stop all processes that modify the database, clone it, drop/rename the old one, and rename the new one with the same name as the old one. Needless to say, this is not scalable.
Thanks.
v-xiaoyan-msft
on:
export to excel
Idrissshatila
on:
Power Query Filter Rows Basic UI bug