cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jorge_Rodrigo Frequent Visitor
Frequent Visitor

Exercise 2: Import Data from a Folder Containing CSV Files HELP

Hi. I have some problems in this excercise i hope some one coudld help me.

 

I download the zip file with 4 files in CVS the file names are:

 

1.png

 

I have import the files into the power bi, rename the query and also combine this 4 files

 

2.png

 

When i combine this 4 files y get 4 steps aplied.

 

3.png

 

4.png

 

I use the last step to remove the headers of the colum Country and the i filter the date after 31/12/1999 (here i chenge the data into dates)

 

5.png

 

6.png

 

I got problems from here the point 4

 

Edit the Sales Query from the US Sales.

 

I dont find anywhere the USA sales. i have from the last excercise the sales query

 

7.png

 

But in this query i dont find any where the USA sales, USA country or NULL cells.

 

8.png

 

9.png

 

A did anything wrong in any step or i miss some step.

Please HELP

Thanks

Rodrigo.

Note***

I have change my settings in regional configuration into English United States in the Editor and Power Bi Deskpot

 

1 ACCEPTED SOLUTION

Accepted Solutions
BhaveshPatel Super Contributor
Super Contributor

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

As you follow along, You have to append International Sales table to the Sales Table in your  query.

 

This will create null values in the country column which can be converted to the USA by either creating Custom column or conditional column.

 

Hope this helps.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
4 REPLIES 4
BhaveshPatel Super Contributor
Super Contributor

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

As you follow along, You have to append International Sales table to the Sales Table in your  query.

 

This will create null values in the country column which can be converted to the USA by either creating Custom column or conditional column.

 

Hope this helps.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Jorge_Rodrigo Frequent Visitor
Frequent Visitor

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

Thanks for your time, you help to solve the Exercise.

 

Thanks

 

Jorge Rodrigo

Highlighted
linsaybrith Frequent Visitor
Frequent Visitor

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

Thanks. You helped Me a great Deal

Dom2018 Frequent Visitor
Frequent Visitor

Re: Exercise 2: Import Data from a Folder Containing CSV Files HELP

I am unable to import them. It just says Zip file.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 156 members 2,266 guests
Please welcome our newest community members: