Forum Discussion
Failed to Import Data
Is it at all possible to use the content pack with NAV 2015?
I'm getting the Code400 error after configuring Account Schedule KPI Web Service.
However, I have read here that I have to make sure that the following tables exist:
- ItemSalesAndProfit
- ItemSalesByCustomer
- powerbifinance
- SalesDashboard
- SalesOpportunities
- SalesOrdersBySalesPerson
- TopCustomerOverview
In the default NAV 2015 configuration those tables do not exist, so does that mean they have to be added manually or is there a workaround?
Thanks.
In case still a question these are not NAV tables - they are the names for the of the published NAV Query as web services
Is there any documentation on how those queries were written in NAV 2016?
Maybe more importantly, will the content pack function, if I clone the queries in NAV 2015?
I have been experiencing this issue on 2016 since Microsoft announced the NAV Content Pack (Proof of Concept). It's been a frustrating experience as even though we are a MS Partner I can't seem to get anyone there to help me troubleshoot his issue. Not to mention the missing financial data in the GB demo version! However, It does work with 2015 very well, albeit missing financial data... JUst ensure you rename the Web Service name to powerbifinance in the Account Schedule KPI Web service setup. Ensure the BALANCESHEET Account Schedule is added here too. Then test your Odata url in IE. Hopefully all good and then you can use the NAV Content Service pack to import the dataset, reports and dashboard.
Worked for me on 2015, not on 2016 as the following error shows:
We couldn't import data from Microsoft Dynamics NAV
Make sure you're entering the information correctly.
Activity IDaa6be9ca-e05e-bbce-a07d-86dc96486607
Request ID5553218d-9ca9-4850-a22c-ef604bcc2069
Status code400
TimeWed Jan 27 2016 11:31:29 GMT+0000 (GMT Standard Time)
Version13.0.800.330
Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net