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 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?

 

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.

4 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super 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.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community 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.

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

     

    Regards,

    B Manikanteswara Reddy