Forum Discussion

snandy2011's avatar
snandy2011
Helper IV
7 years ago
Solved

Excel.Workbook function not working

Hi, I am just importing multiple excel file from a folder.For that, I have wriiten a simple M function Excel.Workbook, but it does not work. It shows "The formula is incomplete". See the below scre...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    snandy2011 ,

     

    This as to do with the way you setup your function, if you do it from scratch you need to adjust the way of working.

     

    When having a link from a folder if you notice the first step on the function is what you refer:

     

      Source = Excel.Workbook([content], null, true),

    However in the combination of the files the first step is:

    = Folder.Files("C:\Folder")

    And you invoke the custom function from the C:\Folder.

     

    So you are refering the folder path, however this depends on how you setup your function.

     

    Regards,

    MFelix

snandy2011's avatar
snandy2011
Helper IV
7 years ago

hi MFelix ,

 

Thanks for replying.. i have used combine features before on PBI.but,my question was that, why the same code is not working on PBI,while it is working fine on Excel..yeah, on PBI, i have to do a little bit extra.that is, mentioning the location of the file.

 

anyway, Thanks for replying..

 

Regards,

snandy

Stachu's avatar
Stachu
Community Champion
7 years ago

looking at the formula description in #shared it does have 3 arguments, but only 1st one is mandatory (binary), and on my side I couldn't replicate the issue when passing only 2 arguments. Could it be that one of the binaries is not Excel?

maybe try something like

Excel.Workbook([Content], true, null)