Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
moe_elbohsaly
Helper I
Helper I

Data Source Connection Error

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

Cluster URI: https://api.powerbi.com

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

1 ACCEPTED SOLUTION

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

View solution in original post

8 REPLIES 8

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.

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

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.

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

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.

Error codeDMTS_DatasourceHasNoCredentialError
Data source errorDatasource has no credentials
Activity Idd528493e-c3ea-47ff-b420-ac7782a77178
Request Id6d7edd46-7617-436e-868b-b93eedab0c84
TimeFri Sep 30 2022 10:26:10 GMT+0300 (Eastern European Summer Time)

What about this error code? ErrorCode=-2147467259

I am in Power Query window

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors