Forum Discussion

aoliver's avatar
aoliver
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 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

 

Need Help

3 Replies

  • v-piga-msft's avatar
    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

     

    • aoliver's avatar
      aoliver
      Helper 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