Odata problem

[rene_rosendal]

When loading data from Odata into Power BI, it get this error on a few tables: "DataSource.Error: OData: Cannot convert the literal '12659684' to the expected type 'Edm.String'."

The rest of the tables are loading as planned. 

I am loading a company's CRM data from hubspot via a localhost server using the software

Cdata Cloud Driver for Hubspot. 

Hope you can help

[greggyb]

Looks like a type conversion error. What data type are you expecting in that field and what is set up in PQ?

[rene_rosendal]

I have rows with different data types in the table - a mix of string, integer, doube and datetime. Excately like the other rows, which it loads without any problems. 

I am sorry, but I am not sure what the PQ means.