Unable to connect to the data source {0} on app.powerbi.com

[Anonymous]

Hi all,

I've been having this issue when trying to create a scheduled refresh for my dataset. This applies to almost all of the new reports/datasets that I'm publishing to the Power BI server. 

I have verified my credentials on other data, and those seem to be working fine. Wanted to note that I didn't create the gateway cluster, but I've been made an administrator.

I've also tried downloading the gateway application to my desktop, logging in, and registering another gateway to the cluster (shown below) but it doesn't show up in the gateway cluster on the website.

Appreciate any help, thanks in advance!

[v-easonf-msft]

Hi , @Anonymous 

Not sure what caused it.
It is suggested to open a support ticket with MSFT to seek technical support.

MS engineers  will look into the issue on your side and provide better suggestions.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @Anonymous 

The only required ports and IP addresses are those needed by Service Bus.

You also can get the list of required ports by performing the Network ports test periodically in the gateway app.The test results list all the servers, ports, and IP addresses that your gateway requires.

"Could not find a  part of  the path XXXX" this error message can be caused by error path.Did you change the location of the original data source？Please check you excel  resided in the same location.  Make sure the powerbi desktop file paths match.

You can download this pbix file to check whether it can  successfully refresh in powerbi desktop first.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi @v-easonf-msft,

I made sure the specified port was open, tested it, and got no different results. 

For the data source, the file path is exactly the same as it shows on my computer, and I haven't modified the location of the data source ever. 

What I've forgotten to mention however is that my co-worker and I are both uploading reports to this same gateway, and his computer is the one that the main gateway is on; however, I've created another gateway and added it to the same cluster, but any data sources I upload default to the gateway on his computer instead of mine. Could that be the issue as to why his computer is unable to connect to the data sources on my computer? And if so, why can't I upload reports/datasets to my own gateway and be able to refresh it on the Power BI server, considering it's in the same gateway cluster?

[Anonymous]

 Here is a similar error message from when I tried to refresh the data today, hopefully this helps.

[v-easonf-msft]

Hi, @Anonymous 

Have you checked the firewall settings？

Make sure the corresponding port is not blocked.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi Eason,

How do I figure out what port corresponds to the Power BI server? Is this on my desktop or on the server somewhere?

Kevin

[lbendlin]

login to the VM where the primary (anchor) gateway cluster member is running and check that everything there is working ok. Check the gateway version too to make sure you are running 63.6

[Anonymous]

Everything is working alright on the VM, and the gateway version on both computers is 63.6.