Forum Discussion
invoke custom function
Thanks for support. I am preetu sure it is a bug in a Power BI. I wrote the function to compare filename with calculated filename.
For some files it is working fine
and for some it is not
I copied both values from 2nd row to column in excel and I removed duplicates. Those cells are equal, and comparision is not working fine. On a screen there are different types, but it does not change anything.
Hm. I find it highly unlikely this is a bug in powerquery. Comparisons are fundamental for the reliability of PowerQuery. I have not heard anyone else about this bug or encountred it myself.
My proffesor in college always said: "don't blame the compiler, debug your program."
The screenshots you send show something, but without seeing all the M code leading to it, I can not help you. In your situation I would start with trying to replicate the issue with local files (with Folder.File()). I could try this as well...
And try some of the tips I gave you earlier.
The quicker method is probably to use my suggestion to solve this with a merge though. This has other benefits as well.