Power Query Data Source Error Odata

[loganf5]

I am getting this error message when connected to a Business Central OData source. The data source error says, "The property does not exist on type 'NAV.Item_Card_Excel'. Make sure to only use property names that are defined by the type or mark the type as open type".  The data set loads, but when in the power query I get this error.

What is causing this data source error?

[v-bmanikante]

Hi @loganf5 ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

Regards,

B Manikanteswara Reddy

[V-yubandi-msft]

Hi @loganf5 ,

Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.

[V-yubandi-msft]

Hi @loganf5 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Akash_Varuna · Accepted solution]

Hi @loganf5 It might be due to a missing or renamed field in NAV.Item_Card_Excel, or Power BI caching an outdated schema.Please try these 

1. Field Renamed/Removed – Check Business Central if the field exists and update Power Query accordingly.

2. Metadata Refresh Issue – Clear and refresh metadata in Power Query:

   • Go to Power BI > Transform Data.

   • Click Data Source Settings > Select your OData source > Edit Permissions > Clear Permissions.

   • Reconnect to the source and refresh the query preview.