Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
Proud to be a Super User!
@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!!!
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.
Proud to be a Super User!
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |