Forum Discussion

loganf5's avatar
loganf5
Regular Visitor
1 year ago
Solved

Power Query Data Source Error Odata

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 proper...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

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.