Forum Discussion
How do I locate this error: "Invalid token, Line 1, Offset4, [) )."
I saved a copy of the original excel file, then re-pointed PowerBI to the new file. I had a little bit of clean-up to do from there, but it seemed to clear up whatever the issue was. Thanks for helping me along and giving me some additional ideas to look into.
Community Championtypically that is referring to the M code. M and DAX natively know nothing of Excel once the data is brought in on the source and navigation lines. Then it just becomes data in the query tool or DAX model. If there were an error in the 4th column, it would either specifically reference the column name in the error, or give you something like this when you load the data.
Or it will do give you an invalid token with some sort of syntax error, which is what I was trying to find. Very hard to know without the actual data file.
Go back to the table in Power Query and in the upper left, tell it to keep errors. Then look at the data that is left and see if you can find fields with errors. Report those error messages back here.
I saved a copy of the original excel file, then re-pointed PowerBI to the new file. I had a little bit of clean-up to do from there, but it seemed to clear up whatever the issue was. Thanks for helping me along and giving me some additional ideas to look into.