Publishing succeeded, but the published report can't connect to the data source.

[Anonymous]

Connected to SQL database created a report and tried publishing.

The error says that the published report can't connect to the data source.

 

Please help me resolve the issue.

Thanks in advance 🙂

[v-yuezhe-msft]

@Anonymous ,

You would need to configure Power BI gateway and add the SQL Server data source within the gateway. For more details, please take a look at this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql.

Regards,
Lydia

[Anonymous]

Followed the steps and faced below error, while adding data source

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	44c22105-654d-4da1-977b-b84b73c59f6f
Request ID:	52d522aa-125c-4a12-da55-7504fddb1a3d
Cluster URI:	https://wabi-north-europe-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Wed Mar 06 2019 14:34:47 GMT+0530 (India Standard Time)
Version:	13.0.8621.151

SUIT PlayBack Gateway Latest:	Invalid connection credentials.
Underlying error code:	-2146232060
Underlying error message:	Login failed for user 'ingrnet\schaowla'.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2146232060
DM_ErrorDetailNameCode_UnderlyingNativeErrorCode:	18456

Troubleshoot connection problems

[v-yuezhe-msft]

@Anonymous ,

Please install Power BI Desktop or SQL Server Management Studio(SSMS) in the gateway machine,  then check if you can connect to the SQL database in SSMS or Power BI Desktop.

Reagrds,
Lydia

[Anonymous]

I'm able to connect to the dataset in Power BI Desktop.

But getting the error while publishing.

[v-yuezhe-msft]

@Anonymous ,

Due to that you haven't added SQL Server data source within gateway, the above warning throws. Do you install Power  BI Desktop and Power BI gateway is same machine?

Regards,
Lydia

[Anonymous]

@v-yuezhe-msft 

Yes, I installed them both on the same machine.

[v-yuezhe-msft]

@Anonymous ,

You would need to add SQL data source within the gateway following the guide in this article. If you still get errors when adding SQL data source in gateway, please export gateway log here.

Regards,
Lydia