Showing results for 
Search instead for 
Did you mean: 
coler Frequent Visitor
Frequent Visitor

Failed to Import Data

Failed to import data
Do you want to delete the dataset and report?
Activity Id520a9703-d195-47bc-ba69-948cff87e9a3
Request Id7ff90775-83b5-0c90-73e8-9fa68aa1e1c5
Status Code200
TimeTue Oct 20 2015 11:36:06 GMT-0400 (Eastern Daylight Time)
Cluster URI


We are trying to connect on the Microsoft Dynamics Nav service from the Power Bi website.

Anyone have any ideas? Thanks. 

Super User
Super User

Re: Failed to Import Data

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

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

coler Frequent Visitor
Frequent Visitor

Re: Failed to Import Data

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 Regular Visitor
Regular Visitor

Re: Failed to Import Data

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!

coler Frequent Visitor
Frequent Visitor

Re: Failed to Import Data

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.  

TristanKuesters Regular Visitor
Regular Visitor

Re: Failed to Import Data

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

scarbajo Frequent Visitor
Frequent Visitor

Re: Failed to Import Data



After hours trying to connect to the demo I finally got it working.


This is my scenario:


Azure VM NAV 2016 demo environment


Nav Instance with Certificate Thumbprint and NavUserPassword authentification.


SSL disabled on Odata.


The trick here is that, even Power BI says it's mandatory to use https, it only will work with http after disabling SSL on OData...


Hope this works for you too.





amrwafa New Member
New Member

Re: Failed to Import Data



Same problem here, even after SSL disabled in ODATA and using is connecting but error while downloding...


Status Code 200


Any help?




TristanKuesters Regular Visitor
Regular Visitor

Re: Failed to Import Data

Did somebody get an answer from Mircosoft about this issue?

Still doesn't work with my demo environment... Smiley Sad

WhyOhWhyPowerBI Frequent Visitor
Frequent Visitor

Re: Failed to Import Data

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)


Cluster URI"


With PowerBI I always feel so close, yet so far... 




Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 80 members 1,294 guests
Please welcome our newest community members: