Reply
Regular Visitor
Posts: 25
Registered: ‎09-06-2017
Accepted Solution

data source error while connecting a folder

Hi All,

 

 I am getting an error while connecting the Data source as a "Folder" to do schedule refresh. I have installed gateway in my computer, but not able to connect the folder to do a scheduled refresh, where I am going to publish this one to my colleagues. 


image.png


Accepted Solutions
Highlighted
Moderator
Posts: 9,201
Registered: ‎03-10-2016

Re: data source error while connecting a folder

[ Edited ]

@nagoor,

Do mask sensitive data before uploading screenshot.

Check your user account in the Settings of your computer,  enter this user account(domain\user in my scenario) as Windows username when adding Folder data source under gateway, and enter relevant password of this account(ensure the password is correct). This way, you should have no issues setting schedule refresh for your dataset using on-premises gateway.
2.png1.JPG



Regards,
Lydia

View solution in original post


All Replies
Highlighted
Moderator
Posts: 9,201
Registered: ‎03-10-2016

Re: data source error while connecting a folder

[ Edited ]

@nagoor,

Do mask sensitive data before uploading screenshot.

Check your user account in the Settings of your computer,  enter this user account(domain\user in my scenario) as Windows username when adding Folder data source under gateway, and enter relevant password of this account(ensure the password is correct). This way, you should have no issues setting schedule refresh for your dataset using on-premises gateway.
2.png1.JPG



Regards,
Lydia

Regular Visitor
Posts: 25
Registered: ‎09-06-2017

Re: data source error while connecting a folder

Thanks, Lydia. 

 

It's worked

Frequent Visitor
Posts: 5
Registered: ‎10-23-2018

Re: data source error while connecting a folder

anyone know if it is possible to use \\server\share instead of C:\whatever ? 
or does this Gateway software only allow connections to the local server where it is installed?  

I want to find a way to connect to an internal fileserver share and pick up files.    

Unable to connect: We encountered an error while trying to connect.

Details: "We could not register this data source for any gateway instances within this cluster.

Please find more details below about specific errors for each gateway instance.

"Hide details Activity ID: a7cexxxxxxxxxxxxxxxxxxxx

Request ID: 748xxxxxxxxxxxxxxxxxxxxxxxx

Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net

Status code: 400

Error Code: DMTS_PublishDatasourceToClusterErrorCode

Time: Tue Oct 23 2018 10:15:35 GMT+0200 (Central European Summer Time)

 

Version: 13.0.7055.182

 

PowerBIGatewayEU: Cannot connect to the mashup data source.

See error details for more information.

Underlying error code: -2147467259 Underlying error message: An IO error occurred while trying to access the file '\\xxxxxxxxxx\xxxx'.

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259

Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

Occasional Visitor
Posts: 1
Registered: yesterday

Re: data source error while connecting a folder

[ Edited ]

Hi I am also getting same error, but after giving the domain name also the error presisit, can some one help me