cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OscarIvanCampos Frequent Visitor
Frequent Visitor

Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi all,

 

We are currently setting up the on-premise gateway in our organization. I have managed to set up the connection to our SQL server. But I am just having issues when attending to set up a data source type "Folder". 

I got the following error message:

 

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.  

 

Has anyone encountered and solved this issue in the past? Any help would be really appreciated. 

 

Thank you, Oscar

19 REPLIES 19
Super User
Super User

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi there

It would be that the folder you are specifying does not exist on the Gateway Server.

For example if the folder is stored on your PC in C:\Intel

The Gateway Server is a different physical machine and does not have the folder C:\Intel

You would need to share the folder and then use the Folder Share Name to connect to it.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
OscarIvanCampos Frequent Visitor
Frequent Visitor

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi Gilbert, 

 

Thanks for your replay and help with this.

 

The folder actually exits on the server where the gateway has been installed. And the path works if I copy and paste it in any new folder. So, opened the location where the data is. 

 

What else could be happening? 

 

Thanks, Oscar

 

 

 

 

Super User
Super User

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi there

Does the account that the Power BI Service uses for authentication to the folder have access to the folder?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
OscarIvanCampos Frequent Visitor
Frequent Visitor

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Yes, it does. 

Super User
Super User

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

From the error, it would appear that it does not, if you could possibly enable the verbose logging in the data gateway to see where the error is coming from.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
OscarIvanCampos Frequent Visitor
Frequent Visitor

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

How can I do that? 

Highlighted
Super User
Super User

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi there

here is a link explaining how to do it.

It is also on the gateway under Diagnostics and then "Additional Logging"

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
OscarIvanCampos Frequent Visitor
Frequent Visitor

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Thanks Gilbert for your help and support so far. 

 

I have configurated the verbose logging. I also followed the steps in the link provided, but I did not find this file Microsoft.PowerBI.EnterpriseGateway.exe.config  in the C:\Program Files\On-premises data gateway path. 

 

 

Super User
Super User

Re: Setting up a new data source in on-premise gateway (Folders within a internal network)

Hi there

Double check if you have enabled the option to show system files, maybe it is hidden?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog