Forum Discussion
power query refresh really slow- excel file
Hi ddm123,
I find a similar post for this problem, you could try to refer to Any way to speed up really slow refresh times in Power Query? | Power Query | Excel Forum for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
I undestand. Then I can't figure out how these 4 lines of everey sheet are removed after you've combined them.
I would go for
- Create one query that threahts your file like you need it
- Create a parameter with one path/name of a sample path
- replace the filename in your first query with the parameter and convert it to a function
- use the data source to extract the file names of this folder... in case do some filtering
- add new column where you use your funciton and path and name as input.
That should do the trick
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello Anonymous
I undestand. Then I can't figure out how these 4 lines of everey sheet are removed after you've combined them.
I would go for
- Create one query that threahts your file like you need it
- Create a parameter with one path/name of a sample path
- replace the filename in your first query with the parameter and convert it to a function
- use the data source to extract the file names of this folder... in case do some filtering
- add new column where you use your funciton and path and name as input.
That should do the trick
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy