Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
sweet_kiss55555
 | Femeie
25 ani
Bucuresti
cauta Barbat
30 - 53 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 916
|
|
If you happen to open one of the Power Query source files from within a folder (when Power Query source is a folder), Excel creates a temporary file starting with "~$" and the name of the file you opened.
This creates temporary errors in Power Query, because it tries to get the content of that temporary file as well.
If that happens, the solution is to insert a step right after Source and exclude file names starting with "~$".
Either you do this manually by filtering that column and adding Text Filter - Begins With... and adding those 2 characters above, or by inserting a new step after Source and adding the formula below:
| = Table.SelectRows(Source, each not Text.StartsWith([Name], "~$")) |
|
|
| pus acum 5 zile |
|