Ingest data with a pipeline in Microsoft Fabric

[naveen73]

Hi,

I am doing this excercise:

https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/04-ingest-pipeline.html

This is what it says at the end:

8 . In the hub menu bar on the left edge of the portal, select your lakehouse.

9. In the Explorer pane, expand Tables and select the new_sales table to see a preview of the data it contains. This table was created by the notebook when it was run by the pipeline.

This is what I have in the Explorer pane (after doing a "refresh"):

What am I doing wrong, please?

Thanks,

Naveen

[Noeleke1301]

Seems to me that you're missing something from step 6, wherre you rename the table.

1. Select the Notebook activity, and then in the pane below the design canvas, set the following properties:
   • General:
     • Name: Load Sales notebook
   • Settings:
     • Notebook: Load Sales

     • Base parameters: Add a new parameter with the following properties:

       Name Type Value

       table_name

       String

       new_sales

       
       The table_name parameter will be passed to the notebook and override the default value assigned to the table_name variable in the parameters cell.

[naveen73]

Hi,

Thanks for your response.

Please see my screenshot below

1. I only read the part that I did something wrong in step 6 so I went back and re-did step 6 and this is the end result. Is this correct?
2. What I do not understand is that it says in the step: “new_sales table to see a preview of the data it contains”. How do I preview the data that it contains, please? Do they mean that the names of the columns should be visible when I expand or do they mean that on the right I should see the actual table.
3. When I type "df" in a cell in my notebook I am getting error message. “NameError: name 'df' is not defined” (see screenshot).

I am lost as to what the purpose is of this labs, really. In my opinion, it is writen by developers for developers, not for learners of this product. Or maybe I am not the correct audience to do these labs?

Thanks,

Naveen

[Noeleke1301 · Accepted solution]

Hi @naveen73 

I'm still very much learning myself as well. Don't be frustrated that things are not working the first time, that's part of the process!

Not 100% sure, but I think you need to use df.show() to get a preview of your dataframe, instead of just 'df'. Have you tried that?