Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Adding a folder as a data source on the on premise data gateway

Hello

 

I published a report on Power BI services that has 2 datasets (excel) imported from our network folder and the IT team that manages the on premise gateway has added a folder as a data source (shared with me). I was told by the IT team that even though my excel files are located in sub folders that the gateway can still connect to it and refresh the data.


However,  i get the following on the settings page. Down on the data source credentials view it says "Failed to test the connection to your data source. Please retry your credentials." When i edit the credentials the path points to the subfolder that was shared with me with authentication method of "windows without impersonation" and i set the privacy to "organisational". However nothing happens when i hit sigh in. 

 

Will my IT admin need to point to the excel files and mapped it directly for me on the gateway?

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Problem solved. I had to change the data source to "folder" and change the directory name (instead of xxx drive to \\XXX\X etc).

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Problem solved. I had to change the data source to "folder" and change the directory name (instead of xxx drive to \\XXX\X etc).