Problem finding Text/CSV-file

Question

Hey

My problem is this:

When I reach this chapter, which is the last, it says:

Get data from a CSV file

In this task, you'll create a new query based on CSV files.

To add a new query, in the Power Query Editor window, on the Home ribbon tab, from inside the New Query group, select the New Source down-arrow, and then select Text/CSV.

Navigate to the 01-prepare-data > ResellerSalesTargets.csv file. Select Open.

But I can't locate the files. I can't find the path: 01-prepare-data > ResellerSalesTargets.csv

I have tried copying them from the folder in the bottom of the screen, see picture:

But it seems to give me problems in the next lab, lab 2. I think it had problems connecting to them.

Please help me, what to do?

This question is related to the following Learning Module

Answer 1

Hi,

Did you open Edge, download the 01-prepare-data.zip from GitHub and extract it in the Downloads folder as instructed in an earlier step?

If yes, when you attempt to open the ResellerSalesTargets.csv as shown in your screenshot navigate to Downloads --> 01-prepare-data folder and it should be there for you to select. See screenshot below to give you an idea of what it should look like:

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

Hi SuneRoedJeppesen-0182,

Thank you for reaching out to us on Microsoft Q&A forum.

Kindly follow the below steps.

Step 1: Open the browser and click the 'T' and + enter highlighted on the right side below Get Started.

Step 2: Open the local disk C folder as highlighted. Kindly refer to the path below.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Answer 3

I have the same problem. I solved it by going to the downloads where it is visible (its visible when you go to the download through the browser Cntrl+J) and copying the exact ResellerSalesTargets.csv file (not the Zip) to a new location in the PowerBi file when you hit new source and then pasting and re-opening it from PowerBI itself.

I do not know if what I said makes sense, i tried to be detailed but it worked.