PowerBI Refresh Failing through Service

[asamr]

Hi,

I have a project which is failing through refresh in the service, but can refresh manually through the PBIX.

The error message is stating different tables being the culprit.

[asamr]

Could it be that the MYSQL server i am pulling data from has the charset utf8mb3 and that us too old for the service, and it can only handle utf8mb4 now?

[ibarrau]

Yes. An special char can break a value in a column producing an error.
You can validate that opening Power Bi Desktop and looking for the row keeping the char at the Transform Data Menu. If an error shows at some point in the value of the column, that can be it.

I hope that make sense

[ibarrau]

Hi. It says that at Table Vouchers there is a column containing a special character that can't be read at Power Bi Service. Try opening Power Bi Desktop Transform data menu (query editor) and keep all columns errors of the table to check if you can find it.

Power Bi Desktop has the ability to ignor some column errors that might be shown at service. You need to find that character or failure at a column.

I hope that helps,

[asamr]

Yeah I am checking. I tried that and I have taken SS of this:

[JR-DCPS]

The column statistics probably won't help you on this one if it is indeed a value that works in Desktop but on on Service. You'll need to search through the table.

Is the error you're getting from automatic refreshes on the server or do you get the same error when you run a manual refresh? If it returns different error codes each time or works on a manual refresh that's a different issue within Service.