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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
atleast2charact
Frequent Visitor

dataformat.error

Hello, 

 

I'm trying to upload one report to our server and ran into a weird issue. The report update fine on Powerbi desktop, but once on the server I get a DataFormat.Error when I try to update it. I've managed to delete some of my datasources to find which one is "problematic", but since everything is fine on the desktop version I canno't figure out the problem. Have you ever encounter this kind of problem, 

 

Regards,

2 REPLIES 2
atleast2charact
Frequent Visitor

I ended up deleting all of my datasources to only keep the two problematics and notice the problem only happens when I combine both of the last sources. One was a basic 4 column/ 4 rows Excel export file, the other one is bigger and used to link some of our reports. If I copy the page I need in a new Excel file and use this one I do not get any error.

 

I beleive problem might be the access to the file (only read write now) or the fact that the file is an old .xls. Waiting on the file owner to change our PBI user access and/or convert the file to xlsx. I've save the file as an xlsx and it's working as well this way.

atleast2charact
Frequent Visitor

Here is exactly the error I get on the server, PowerBI Desktop updates are good

 

SessionID: 928d86c6-0e26-4ddd-a03a-fe876b9b6499
[0] -1055784932: DataFormat.Error: We couldn't convert to Number.. 10.0. ;We couldn't convert to Number.. The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784934: The command has been canceled.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[7] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.