cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagoor Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: data source error while connecting a folder

@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

Community Support Team _ Lydia 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

4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: data source error while connecting a folder

@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

Community Support Team _ Lydia 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

nagoor Regular Visitor
Regular Visitor

Re: data source error while connecting a folder

Thanks, Lydia. 

 

It's worked

Highlighted
nmj40 Frequent Visitor
Frequent Visitor

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

arunv Occasional Visitor
Occasional Visitor

Re: data source error while connecting a folder

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 1,162 guests
Please welcome our newest community members: