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.

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
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.