Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

M-Code "Table.buffer"

Hi    in my Bi File i have merged historical files in one table and i wish to use below M-Code or only Table.Buffer , due to lack of knowledge i not understanding where do i need to use this M-Code...
Need Help
Tutorial Requests
  • KNP's avatar
    KNP
    6 years ago

    Hi Anonymous ,

     

    Did you find the info you need? The use of Table.Buffer can require quite a bit of trial and error to get right and really does vary from query to query. Firstly, in the code you posted, you need to move the Table.Buffer inside the "="

     

     

    //Change this...
Table.Buffer(Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),

//To this...
Source = Table.Buffer(Excel.CurrentWorkbook(){[Name="Table1"]}[Content])),

     

    Secondly, and perhaps more importantly, that may not be the right step to introduce the buffer. If you can post more complete code you might make it easier for others to assist.

     

    Regards,

    Kim 

KNP's avatar
KNP
Super User
6 years ago

Hi Anonymous ,

 

Did you find the info you need? The use of Table.Buffer can require quite a bit of trial and error to get right and really does vary from query to query. Firstly, in the code you posted, you need to move the Table.Buffer inside the "="

 

 

//Change this...
Table.Buffer(Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),

//To this...
Source = Table.Buffer(Excel.CurrentWorkbook(){[Name="Table1"]}[Content])),

 

Secondly, and perhaps more importantly, that may not be the right step to introduce the buffer. If you can post more complete code you might make it easier for others to assist.

 

Regards,

Kim