Data Source Connection Failed

[trpeel]

When trying to run a report, we get this error:

Data source connection failed

Unable to connect to the data source xxx . Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration on the  dataset settings page and contact a data source administrator to troubleshoot this issue.Unable to connect to the data source {0}. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration on the {1} and contact a data source administrator to troubleshoot this issue. 

When we look at the dataset settings page, we get this message saying the refresh failed:

data source error:

{"error":{"code":"DM_GWPipeline_Gateway_InvalidObjectNameException","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidObjectNameException","parameters":{},"details":[],"exceptionCulprit":1}}}

The gateway connection says it's running with a green checkmark. The data sources included in the dataset have a green checkmark. The data source credentials says "(admin has granted access, credentials are not required)".

I've verified the database exists and is accessible. Not sure about the credentials because of the message above about credentials are not required.

Any ideas or tips? Much appreciated!

Tye

[SaiTejaTalasila]

Hi @trpeel ,

Copy that table m-query and create a new dataflow in your workspace>take blank query>paste that query and save that query and check whether the same issue occurs or not.

Thanks,

Sai Teja 

[navinrangar]

in my case the issue was related to 'not installing connector for my MySQL database'. MySQL and some other databases are required to have database connectors (odbc, jdbc etc) to interact to enable interaction with database, and a data gateway to securely transfer that data to and fro.

[Anonymous]

I have the same issue and I think it's because I merged 2 tables from different sources. SQL & Web (Sharepoint)

[KeerthanA_99]

Hi Team,

"What is the way to create connection from power BI https://app.powerbi.com/ to RDS (postgress).
This RDS is private and not accessible to internet
And we are able to connect it from Kubernetes clusters.

But from power bi getting below error

[ecancino]

I have the same problem

[navinrangar]

i guess, you should first expose it for the 'remote access'.. there must be an option to do so in your remote db. check that.

[Anonymous]

Hi @trpeel ,

Have you renamed or shifted the path of your data source?  

First, make sure your gateway is the latest version. Then you can try to connect in the desktop according to the information of the data source you configured on the service. If an error occurs, you will know if there is a problem with the data source based on the error. If the data source is fine, you can try republishing the dataset and reconfiguring it.

You can also refer to this doc for more useful information: Troubleshoot gateways - Power BI | Microsoft Docs

Best regards,

Community Support Team Selina zhu

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

[Greg_Deckler]

@trpeel Try turning on advanced logging on the gateway and rerun the refresh. You should get additional details about what is going on. Also, make sure that your gateway is current.