Load Error - DataFormat.Error

[khaycock]

Everything looks perfect in my Transform queries but then bam when I load and save I get this pop up. I have no idea how to solve it because I don't even have a query called Professional Targets anymore, let alone anything with data to convert to number. There is no such table ANYWHERE in the data anymore and I don't know what to do 😞 help please!! 

[v-janeyg-msft]

Hi, @khaycock 

You need to check whether the table name, column name and data type of the data source are consistent with those in powerbi, and chcek if date type in PQ navigation bar is 'any'. Try to reconnect the data.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[sayaliredij]

It looks like you have one column automatically converted to Number based on sample data. But it actually contains text values. 

Try to convert number columns into text for testing purpose

Regards,

Sayali

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

[khaycock]

I've just gone through every single query/field and every single field is text except if its a figure or a date. I don't understand why it's looking for a table that doesn't exist anywhere?