Reply
Highlighted
Frequent Visitor
Posts: 6
Registered: ‎06-15-2016
Accepted Solution

In PowerBI, why am I getting Connect & Convert errors when trying to load data (edX Lab 1 step 8)?

In the edX Power BI course (Lab 1, step 8) after I remove the country column and click "Apply and Close", I get the following two errors:

 

  1. OLE DB or ODBC error: Exception from HRESULT;

  2. OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.. Power-BI-Course-ERROR-Connect-Convert.png

 

See screenshot, attached.


Accepted Solutions
Regular Visitor
Posts: 21
Registered: ‎07-28-2015

Re: In PowerBI, why am I getting Connect & Convert errors when trying to load data (edX Lab 1 st

Hi, this step its important:

 

  • Filter the rows that come from the header of the CSV files. (Hint: One way to do this is to filter out the Country column from records containing “Country”).

This step is for remove these rows:

 

Error.PNG

 

View solution in original post


All Replies
Regular Visitor
Posts: 21
Registered: ‎07-28-2015

Re: In PowerBI, why am I getting Connect & Convert errors when trying to load data (edX Lab 1 st

Hi, this step its important:

 

  • Filter the rows that come from the header of the CSV files. (Hint: One way to do this is to filter out the Country column from records containing “Country”).

This step is for remove these rows:

 

Error.PNG

 

Frequent Visitor
Posts: 6
Registered: ‎06-15-2016

Re: In PowerBI, why am I getting Connect & Convert errors when trying to load data (edX Lab 1 st

Yeah, that's a great point! Once I filtered on Country = 'Country' (and removed those rows), all I had to do was remove the errors for the 'Date' field and it worked perfectly - so thanks!

Frequent Visitor
Posts: 6
Registered: ‎09-16-2016

Re: In PowerBI, why am I getting Connect & Convert errors when trying to load data (edX Lab 1 st

[ Edited ]

When I filter, get that screen, and remove rows, it says there is nothing in the table.  What am I doing wrong? 

Did the remove errors in the data column (not the ribbon) and it worked!