Using PowerBI Connector for ServiceNow

[dianecho87]

I am using Power BIconnector to connect to ServiceNow. I was able to load my data, but I was running into a few issues with my tables, so I decided to re -sync the data again. 

Now , I am running into an error: 

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] OData: Incompatible type kinds were found. Found type kind 'Primitive' instead of the expected kind 'None'.. OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E. The current operation was cancelled because another operation in the transaction failed. '.

I have seen posts where I need to check the data type etc. however I am unable to make changes to the source of data as it is being connected through Odata. 

[Anonymous]

Hi! 

We've built an app for Servicenow and Power BI integration: Power BI Connector for Servicenow. It's easy to use, it's fast and automated. 

On our website https://www.alphaservesp.com/products/servicenow/power-bi/ you could open the documentation and find the answer to your question and we have fast/responsive support team at support@alpha-serve.com

Please let us know if you need any assistance.

Daria 

[dianecho87]

I was able to figure it out. It was due to the data source where I was retrieving duplicate fields. Thank you!

[Anonymous · Accepted solution]

Hi  @dianecho87 ,

This error indicates that the expected data types of the fields do not match, you can check if the data source fields have changed and do not match the stored data structure

You can try refreshing the schema of the affected table in Power Query, which prompts Power BI to reevaluate the type of data to be imported.

Make sure you have the latest version of Power BI Desktop, update to the latest version and then republish:

Download Power BI Desktop from Official Microsoft Download Center

This is the related document, you can view this content:

Solved: The following system error occurred: Type mismatch... - Microsoft Fabric Community

Solved: The data provider was unable to convert the value ... - Microsoft Fabric Community

Solved: Power BI Service not refreshing data - Unexpected ... - Microsoft Fabric Community

Best Regards,

Liu Yang

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