Failed to import dataDo you want to delete the dataset and report?Activity Id520a9703-d195-47bc-ba69-948cff87e9a3Request Id7ff90775-83b5-0c90-73e8-9fa68aa1e1c5Status Code200TimeTue Oct 20 2015 11:36:06 GMT-0400 (Eastern Daylight Time)Version11.0.9168.427Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net We are trying to connect on the Microsoft Dynamics Nav service from the Power Bi website.Anyone have any ideas? Thanks.

we have tried and tried and tried. Using Azure VM with MS Demo DB, followed every post known to man! Turned off SSL for OData, setup basic auth user, still 200 error. I dont understand why MS would release a content pack that is virtually impossible to setup!

Use the smiley icon in the upper right to send an incident and screen shot to support.

Thanks. I started there first and then thought I'd post here to see if anyone had already had this issue. Has anyone actually gotten this to work with NAV 2016?

Tanyad thanks for the reply. We get as far as it gets connected to the odata site and begins to download (we see the dashboard) but then it errors out at some point in the data download. I've got a support ticket created and once (if) there is a resolution I'll post it here.

Same issue on my test, with the same setup (demo environment NAV 2016 on azure, set up SSL to NO) I also created a support ticket!: SR number 115102013285452. Hope we will get help soon...

Failed to Import Data | Microsoft Fabric Community

17 Replies

Greg_Deckler
Community Champion
10 years ago
Use the smiley icon in the upper right to send an incident and screen shot to support.
- coler
  New Member
  10 years ago
  Thanks. I started there first and then thought I'd post here to see if anyone had already had this issue. Has anyone actually gotten this to work with NAV 2016?
  - tanyad
    Advocate III
    10 years ago
    we have tried and tried and tried. Using Azure VM with MS Demo DB, followed every post known to man! Turned off SSL for OData, setup basic auth user, still 200 error. I dont understand why MS would release a content pack that is virtually impossible to setup!
Anonymous
Not applicable
10 years ago
Any update on this would be much appreciated. Microsoft PowerBI support have talked me through disabling the SLL and switching to Http on my NAV demo but when accessing the Nav Content Pack it fails on the data import. The following error appears after around 10-15 seconds of 'LOADING'...

"We couldn't import data from Microsoft Dynamics NAV

Make sure you're entering the information correctly.

Activity Id644142fc-9536-97e6-c684-ecc4a4b41fd4
Request Ide4c6f3a2-ec66-0cd5-769f-b1b4dbd4f715
Status Code400
TimeThu Nov 05 2015 11:50:58 GMT+0000 (GMT Standard Time)
Version11.0.9168.601
Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net"

With PowerBI I always feel so close, yet so far...
- trevoracus
  New Member
  10 years ago
  yes sure would be nice to know why it isn't working.
  
  2016 CU1 same issue. ODATA works fine via https on any other external connection.
  
  Error:
  
  Make sure you're entering the information correctly.
  
  Activity Id3af0e2ec-8933-6b33-eab6-75ddb27c9728
  Request Id6ab3c21d-592e-3ec3-c460-38862cbee6be
  Status Code400
  TimeWed Nov 11 2015 16:16:48 GMT-0500 (Eastern Standard Time)
  Version11.0.9168.604
  Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net
mattvardy
New Member
10 years ago
I have been following these posts on Power BI as I have had the same issue myself. First I could not get past the authentication stage with https and my self-signed certificate so I disabled SSL.

Next I get to the Data Upload stage but the process crashes after 10 seconds. After lots of troubleshooting I found that the powerbifinance web service used by the content pack errors for some localised versions. GB (it errors) because there are no Accounting Period as the UK uses a localisation. I try again, it crashes after 30 seconds. I try all of the Microsoft published web services and find that page 1304 fails, it is failing as an ODATA service because there is a dialog onQueryClose().

I commented out that code. I run my Content Pack test again. After maybe 1 minute - Success. So all webservices must provide an ODATA result.

Matt Vardy
- bhaskarjani
  New Member
  9 years ago
  Hi Matt,
  
  Nice to see your post here.
  
  Can you please elaborate which code you commented out ?
  
  Regards - Bhaskar
- bhaskarjani
  New Member
  9 years ago
  Hi Matt,
  
  Nice to see your post here.
  Can you please elaborate which code did you comment ?
  
  Regards - Bhaskar
Anonymous
Not applicable
10 years ago
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.
- simpson
  New Member
  10 years ago
  In case still a question these are not NAV tables - they are the names for the of the published NAV Query as web services
  - Anonymous
    Not applicable
    10 years ago
    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?

Forum Discussion

Failed to Import Data

17 Replies

Related content

Data Refresh Failed

imported data not refreshshing in visuals

Power BI - Excel Data Import failing due to 32k cell limit

Failed to import data

Import USDA PSD DATA BASE