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

MFelix's avatar
MFelix
Super User
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