Forum Discussion
PowerBI refresh fail - Expression Error.
ianbarker Error is giving you column number and line number and message of Semicolon expected, are you able to pin point that area and check data there. I have seen few times data refresh works fine in desktop but throws error in service. But from error itself it seems to be data related. You can also try removing that column whole and then refresh in service to figure out the exact cause.
ankitpatira My dataset contains 35 tables. Any thoughts on how I might pinpoint the table at the very least?
ianbarker I guess you will have to shortlist tables that has equal or more than 47 columns since it said 47th column. Then look at line 112 of each of those tables and take a guess of which one it could be or one that does require semicolon. In anyway it seem like tidious task and its pity erorr hasn't mentioned table name. What I would do is also create a microsoft support ticket and start figuring out myself as well whichever happens earlier the better.