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
Icon for Community Support rankCommunity Support
1 year ago

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.