Import excel file Adventure works: errors in products table?
Import excel file Adventure works: errors in products table?
When I try to import the excel files (adventure works) I get the message of an error with the products tabel. Do I do something wrong?
- Attachments
-
- products_errors.png (146.07 KiB) Viewed 603 times
-
MattAllington
- Posts: 1154
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: Import excel file Adventure works: errors in products table?
Well I can’t read the error, but my guess is that the size column has been incorrectly set as an integer instead of text. You can edit the query, find the changed type step that set the size as integer, click on this step and then change the type to text. You should be prompted to replace or add a new step. Select replace.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Power BI Training
Return to “Help with the Book "Supercharge Power BI"”
Who is online
Users browsing this forum: No registered users and 0 guests


