Solved: Data Source Connection Error

moe_elbohsaly · ‎09-29-2022

I cannot connect to my data source either through app.powerbi.com or through Desktop.

ActivityId: 7ffeabd1-5b10-4631-8060-8f852bd25372

RequestId: fe1f94dc-7917-4ad8-a9d3-c3cdb4615738

Status code: 500 Time: Thu Sep 29 2022 17:01:26 GMT+0300 (Eastern European Summer Time)

v-yueyunzh-msft · ‎09-30-2022

According to the error message,I think you can check the credential you configured . And you said that it worked in on a previous laptop . You can check whether you use the same gateway , and ensure that the computer on which the gateway is installed can access the data source.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

ribisht17 · ‎09-29-2022

@moe_elbohsaly

Please check https://community.powerbi.com/t5/Service/Status-Code-500/m-p/1958302

https://community.powerbi.com/t5/Power-Query/Status-Code-500-can-t-connect-Power-BI-to-Visual-Studio...

Regards,

Ritesh

moe_elbohsaly · ‎09-29-2022

Do you think it's a server issue? Since I can connect to the data source from different client applications. And the service provider hosting my database still didn't confirm if they have a network downtime.

v-yueyunzh-msft · ‎09-29-2022

Hi , @moe_elbohsaly

According to the results of our background database query, the request ID provided is reported as follows:

"TIMESTAMP": 2022-09-29T14:01:48.5092241Z,

"EventText": Exception object created: Microsoft.PowerBI.DataMovement.ServiceContracts.PowerBIGatewayException: Received error payload from gateway service with ID 1386032: Mashup expression evaluation error. Reason: ..(wrapped: GatewayClientErrorResponseException/Received error payload from gateway service with ID 1386032: Mashup expression evaluation error. Reason: ..),

For this , you can oprn your raw .pbix file and enter the Power Query Editor to check each step under each query for error messages.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

moe_elbohsaly · ‎09-30-2022

I have tried to setup the gateway on a previous laptop I had and it worked! I don't know why these errors emerge once I do the same setup on the desktop.

v-yueyunzh-msft · ‎09-30-2022

Hi , @moe_elbohsaly

According to the error message,I think you can check the credential you configured . And you said that it worked in on a previous laptop . You can check whether you use the same gateway , and ensure that the computer on which the gateway is installed can access the data source.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

moe_elbohsaly · ‎09-30-2022

Both gateways are different because each is a distinct machine. Anyways, I reverted back to the already working laptop and will never both myself to troubleshoot it on the Desktop.