Forum Discussion

aoliver's avatar
aoliver
Icon for Helper III rankHelper 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's avatar
v-piga-msft
Icon for Resident Rockstar rankResident 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

 

  • aoliver's avatar
    aoliver
    Icon for Helper III rankHelper III
    7 years ago

    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