Forum Discussion

giuliapiazza94's avatar
giuliapiazza94
Helper IV
4 years ago
Solved

Path file parameter

Hi guys, I'd want to parameterize the file path with language M but I can't.   For example: I have a file Excel in a folder C:\PBI\WORK so in editor I have   let Origine = Excel.Workbook(File....
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    giuliapiazza94 , Create an M Parameter, say path (under manage parameter, create new)

     

    let
    Origine = Excel.Workbook(File.Contents(path &"\File_01.xlsx"), null, true),
    data_Table = Origine{[Item="data",Kind="Table"]}[Data]
    in
    data_Table

amitchandak's avatar
amitchandak
Super User
4 years ago

giuliapiazza94 , Create an M Parameter, say path (under manage parameter, create new)

 

let
Origine = Excel.Workbook(File.Contents(path &"\File_01.xlsx"), null, true),
data_Table = Origine{[Item="data",Kind="Table"]}[Data]
in
data_Table