Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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( Ref https://www.myonlinetraininghub.com/excel-forum/power-query/any-way-to-speed-up-really-slow-refresh-...)
Table.Buffer(Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),
In my query from my data source i have filtered column by folder location and then split the column for saperating dates from file name and then i added column by using Excel.Workbook([Content]) and after excending that coulumn i used Table.PromoteHeaders(Table.RemoveRows([Data],0,2)) for having table headers and then i am using my data in BI File
Please note that i have link data through Power BI Dataflow to BI report
Please guide me
Solved! Go to Solution.
Hi @Amardeep100115 ,
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
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @Amardeep100115 ,
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
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @Amardeep100115 ,
If you want to know the table.buffer' s function, you could refer to Improving Power Query Calculation Performance With List.Buffer() and Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query for details.
If you want to to combine two files, please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I was looking for solution for getting refresh my query in power query and Power BI Dataflow.
i found this M-coad to be used but as i am not much familier with M-code that why i reach at super users
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |