2

I have created a gateway with SQL connections. I wanted to connect an excel file that is stored on the company's shared folder but I keep getting an error:

enter image description here

I tried changing the file location to: "\\gvnas\GVNAS\N:\01. CORPORATE....\Compiled Dwell Time-Mail.xlsx" but it threw the same error.

enter image description here

I also have a power BI file with the same path and it works fine: enter image description here

Aastha Jha
  • 153
  • 1
  • 2
  • 14
  • You should use file location with the server name and without N:\ because this disc name is only for your PC "\\server\test\01. CORPORATE....\Compiled Dwell Time-Mail.xlsx" – msta42a Nov 01 '20 at 19:46
  • 1
    I tried "\\gvnas\GVNAS\01. CORPORATE ....\Compiled Dwell Time - Mail.xlsx" and it throws the same error – Aastha Jha Nov 02 '20 at 05:54
  • 1
    Did you find any solution on this ? We are facing the exact same scenario here and we can't find a working solution ... – tchartron Feb 15 '22 at 16:44

1 Answers1

-1

Have you check to ensure all system, Power BI and SQL sever have access to the folder your trying to read from?

drcoz
  • 11
  • 4