Gateway Error when trying to create new connections

[knissm]

Hi All,

I'm trying to configure a new data source, which is data shared through a mounted driver.

For some reason when I publish my file and having to migrate the connections to my gateway I am getting errors.

In the first image the connection is not found, then I create a new connection with the files (all .xlsx and .csv)

Apparently the connections are updated successfully:

But if I try to refresh I get errors:

Apparently the gateway can't find the files, I get the same error for all connections.

Does anyone know what could be happening? SQL connections work, the problem seems to be with the .csv and .xlsm files

[aj1973]

Hi @knissm 

The problem is with Test1 and/or Test02. The gateway can't find the file or folder in the path.

[knissm]

But this name is just a name to identify the connection, isn't it?

Because i have the folder's path here

[knissm]

yep, i renamed the connections and the error is still showing

[aj1973]

"Report cards" and "External vulnerabilities" are these files or folders? If files what type/extension are they ?

[knissm]

"Report cards" and "External vulnerabilities"  are both folders

[aj1973]

Combined folders, and the folders contain what type of files? Structure of the files are the all the same?

You need to open power BI desktop and Power Query to verify 

[knissm]

I've already checked, I even started a new report with the files isolated within each folder and I'm still getting an error.

😢

[aj1973]

There's a folder that's attached to your dataset/Report cards. Open the desktop and go to connections parameters, delete the path that's mentioned by the gateway error 

[knissm]

It didn't help, I rebuilt the entire report removing folders and any parameters. 😢