SP list data is not importing correctly into Power BI

[jaytrice26]

In my SP list it shows me all the offices that I manage hardware for and what they have in inventory per item. (For example: the Austin office has 23 professional laptops, 30 docking stations, 50 webcams. They also have a pending order for 50 monitors.)It also shows me if they have pending orders for additional equipment. For some reason when I connect to my SP list from Power BI, none of the data is coming through correctly. Or I should say none of the column names come through and I'm not sure if that's why the rest of the data is not showing correctly. Where it would show me the name of the product( i.e. professional laptop, docking station, webcam, monitor) it is only showing random numbers and letters. In my SP site I have several columns but the only ones I choose to pull in are: part, part: description, location, current inventory, pending inventory, preferred inventory. When I view the table in power bi it is showing column names of: filesystemobjecttype, contenttypeid, authorid, editor, odata_uiversionstring, attachements to name a few. None of the data in those columns are what is shown in my SP list. How can I resolve this issue?

[jaytrice26]

@danextian This solved my issue and it was so easy!!! THANK YOU SOOO MUCH!!!!!!!!!!!! Now I can finally build my report and make it live instead of having to go in everyday and update it manually!!!

[danextian · Accepted solution]

Hi @jaytrice26 ,

You might have chosen the wrong implementation.

Below is implementation 2

Below is implementation 1

These were my settings:

Click the wrench icon next to Source applied step to modify the settings.