Forum Discussion
Using PowerBI Connector for ServiceNow
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.
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.
3 Replies
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.
I was able to figure it out. It was due to the data source where I was retrieving duplicate fields. Thank you!
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 [email protected]
Please let us know if you need any assistance.
Daria
