Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
asamr
Helper I
Helper I

PowerBI Refresh Failing through Service

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_0-1682420513509.png

 

5 REPLIES 5
asamr
Helper I
Helper I

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?

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


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

ibarrau
Super User
Super User

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,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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

 

asamr_0-1682508379958.png

 

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors