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.
|
Nou pe simpatie:
Alesiandra
 | Femeie
24 ani
Cluj
cauta Barbat
28 - 58 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 3 luni#1 |
TRaPModerator
Postari: 962
|
|
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], "~$")) |
|
|
| |
|
