I'm able to connect to the apps but I get error messages about the tables. Has anyone gotten these messages?
NAV - Sales Report:
Messsage: The field 'SalesOrdersBySalesPerson' of the record wasn't found. Table: SalesOrdersBySalesPerson.
NAV - Financials Report
Message: The field 'powerbifinance' of the record wasn't found. Table: PowerBIFinance.
NAV - CRM Report
Message: The column 'Chances_of_Success' of the table wasn't found. Table: SalesOpportunities.
Can you connect to these sources through PBI Desktop without errors?
Yes. The issue doesn't seem to be the connection but what it's connecting to in NAV. These are supposed to be 'out of the box' connections to NAV so why does it require fields that don't exist?
Editing: The fields exist - why isn't it using them? I'm really starting to question the microsoft apps.