How do I locate this error: "Invalid token, Line 1, Offset4, [) )."

[Anonymous]

I can't refresh my data. I'm trying to identify where the error is occuring. How do I read what this code is telling me? I know the table. Is it telling me to look in a particular column within the table to find the error?

[edhans]

Ahh... that could have been some random corruption in the Excel file, which is especially hard to track down. 

Please mark one or more of the posts in this thread as the solution so this thread is marked solved and other can see it. Glad your project is moving forward @Anonymous 

[edhans]

typically 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. 

[Anonymous · Accepted solution]

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.

[edhans]

I don't see a problem off the top of my head, but that is an image with a lot of obscured text, so hard to say exactly.

[Anonymous]

Thanks for looking it over. Do you know what the "Line 1" refers to? And the "Offset 4"? Are those rows (line 1) and columns (4th column) in the excel table?

[edhans]

Post your M code from the Advanced Power Query editor. Use the </> code box to do so in the toolbar please.

[Anonymous]

Is this the correct info?