SDK Power Query - Get data with autentification

[aoliver]

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 autentication. the query is as follow:

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

When I try to import the connector .mez in my powerBI file, it trunks loading the info, and never returns nothing (is like 500 rows, is not a size problem)

I am doing the query in the correct way?

Thanks in advance

[v-piga-msft]

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

[aoliver]

I tried that before but powerBI brings this error:

@v-piga-msft 

If it is possible, try to create a little script to load a local file (f.i excel) into the connector, via SDK of visual studio.

Cheers

[aoliver]

any ideas?