Forum Discussion
Data flow gen 1 extremely slow
Hi jochendecraene ,
We just wanted to check in again regarding your issue. If you've found a solution, marking the reply as the solution and leaving a kudos would be greatly appreciated, it helps the community and others with similar questions.
Additionally, we'd like to share that the known issue related to the slowness of connecting to SharePoint folders in Dataflow Gen1 and Gen2 has been fixed.
If you're still facing challenges or have further questions, please let us know.
Thank you.
jochendecraene If you have any reference queries try Table.Buffer() function to significantly increase your dataflow performance. This function loads an entire table into memory, isolating it from external changes during evaluation. By buffering a table, you can prevent multiple executions of expensive operations and improve performance, especially when working with small lookup tables used multiple times. Use the Buffer function at the last step and Give it a try !
Sample:
let
Source = Sql.Database("SomeSQLServer", "MyDb"),
MyTable = Source{[Item="MyTable"]}[Data],
BufferedTable = Table.Buffer(MyTable) //Buffered the table at the last step
in
BufferedTable
Thanks,
Jai