Forum Discussion

Helper III

7 years ago

SDK Power Query - Get data with autentification

Hi everyone I am working with the SDK of Visual Studio for Power Query in M language, and I have doubts in how can I obtain the data, because the excel file is in a personal server that has windows ...

Need Help

v-piga-msft

Resident Rockstar

7 years ago

Hi aoliver ,

It seems that your file is not the local file.

I'm afraid that the problem is caused by the File.content.

You could refer to the query below and then modify it based on your scenario.

shared Calendario = () as table =>
let     
    Source = Excel.Workbook(Web.Contents("\\"PrivateIP"\c$\Visualizacion\Horarios.xlsx",headers = [ AuthenticationKind="UsernamePassword", Username="username", Password="password" ]),null,true)
in
#"Source";

In addition, you could have a good look at how to use Web.Contents.
Best Regards,

Cherry