Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

ThuraAung

SQL Server connection failed

Submitted by on ‎03-31-2022 01:58 AM

Hi,

It was showing the follwing message when I refreshed the Dataset. Gateway connection was ok.

ThuraAung_0-1648717057239.png

 

-------------------------------------------------

Please try again later or contact support. If you contact support, please provide these details

 

Cluster URI: WABI-EAST-ASIA-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 87d8c65f-a367-41b3-b9e5-5c50e856c0b8
Request ID: 81977640-ac4f-0183-3b52-51f97aa97f90
Time: 2022-03-31 08:47:21Z

Status: Investigating

Hi @ThuraAung ,

 

May I know what’s the connection mode of your report? Is it built with import mode or Direct Query mode?

When did you get this error? Did you get it when refreshing the dataset or accessing its report?

Is this issue keeping happening or intermittent? If you do the same operation again, will you still get this problem?

To successfully connect to SQL Server data source, firstly, you need make sure SQL Server database is running smoothly on the machine that installed it and it can be connected to. Secondly, you need make sure the gateway is working well and there isn’t any connection issue displayed in Manage Gateway page. Thirdly, please check whether your dataset is mapped to related data source correctly.

If it is an refresh issue, please check in the refresh history as well to see if you could find error in details. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
1 Comment (1 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎03-31-2022 10:52 PM
Status changed to: Investigating

Hi @ThuraAung ,

 

May I know what’s the connection mode of your report? Is it built with import mode or Direct Query mode?

When did you get this error? Did you get it when refreshing the dataset or accessing its report?

Is this issue keeping happening or intermittent? If you do the same operation again, will you still get this problem?

To successfully connect to SQL Server data source, firstly, you need make sure SQL Server database is running smoothly on the machine that installed it and it can be connected to. Secondly, you need make sure the gateway is working well and there isn’t any connection issue displayed in Manage Gateway page. Thirdly, please check whether your dataset is mapped to related data source correctly.

If it is an refresh issue, please check in the refresh history as well to see if you could find error in details. Thanks in advance!

 

Best Regards,

Community Support Team _ Caiyun

Idea Statuses