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?
v-xiaoyan-msft
on:
PBI error reports server database after software u...
on:
Header Icon Toggles are missing for Alert and Copy...
on:
Unable to mark a table as date table
Hi @jaytrice26
Are you doing this in Service or Desktop ? Is this the first time you've connected to the SP list to get data?
Best Regards,
Community Support Team _ Ailsa Tao