Problem finding Text/CSV-file

SuneRoedJeppesen-0182 80 Reputation points
2024-07-30T19:36:58.9466667+00:00

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:

User's image

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

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
238 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. TP 84,291 Reputation points
    2024-07-30T20:10:15.6166667+00:00

    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:

    qna pl-300 get data csv file

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

    Thanks.

    -TP

    0 comments No comments