Import excel file Adventure works: errors in products table?

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
eriks
Posts: 9
Joined: Mon Mar 09, 2020 10:56 pm

Import excel file Adventure works: errors in products table?

Postby eriks » Fri Apr 10, 2020 8:03 pm

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
products_errors.png (146.07 KiB) Viewed 602 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?

Postby MattAllington » Sun Apr 12, 2020 7:32 am

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


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 1 guest