01-27-2017 09:57 AM
In EdX class DAT207x Analyzing and Visualizing Data with Power BI for Power BI Desktop Data Transformations > Lab 1 > Exercise 2: Import Data from a Folder Containing CSV Files, I am getting an error when Loading data into PowerBI Desktop. The error is:
International Sales: Load was cancelled by an error in loading a previous table.
Sales: OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
I've spent hours trying to redo this excercise and can't seem to solve the issue. Any suggestions would be much appreciated.
01-31-2017 08:38 AM
try either of these two ways to solve the problem.
- First I did a Compact & Repair on the database
- Then when I selected the database file to open I chose “open as read-only”
01-31-2017 03:23 PM
Thank you for these tips. I reviewed all the ribbon options and was not able to locate a way to Compact & Repair in PowerBI. I also searched the help website and do not know how to do a Compact & Repair. Is there documentation available that shows the steps for this action?
Additionally, I was unable to select "open as read-only" when the lab instructions said: "Import the data from the file folder by using the Get Data. To do this, click the Get Data / More option, select Folder and click Connect. " Is the open as read-only feature in a different step during the import?
I tried again today refreshing all the queries and precisely following the steps in the exercise. And, unfortunately, I still receive the same error as before.
01-31-2017 03:36 PM - edited 01-31-2017 03:41 PM
I tried a different way, and got a new error. I have double checked all query date columns and the format is set to date on each.
02-06-2017 11:45 PM - edited 02-06-2017 11:46 PM
I'm also redo the exercise, it is worked for me, I saw screenshot, could you try to change ProductID Data Type to "Any" in Intermational Sales then do the step again?
02-10-2017 10:09 AM
Thank you for this tip. On further review, the data type of ProductID in Sales is "Any" and the data type of ProductID in International Sales is "Whole Number". However, I do not see how to change "Whole Number" to "Any" as it is not a selection. I have searched the forum on how to do this and did not find an answer. Do you know the steps to take?
02-13-2017 01:29 AM
Sorry, I'm try it again, it maybe not influence for changing Data Type, this is mt result when I follow the step then load the data as below:
02-20-2017 01:18 PM
Thank you for your help. I was not able to solve the problem. However, I did learn quite a bit in the process and have now continued on to the next module.
03-04-2017 11:23 PM
Hi there, I am also having the same issue. I tried to reload the datasets numerous times and changing the ProductID to Any or Whole Number. Still getting the Date error. The locale is set to US as prescribed.
Any help would be much appreciated.