Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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