Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
if you have administrator privileges you could try to get users list from SharePoint. You do this in the same way like for simple SharePoint list, but you must provide appropriate address. I don't have local SharePoint instance to test it, so I'm not sure in 100% that this list will be visible in Power BI Desktop. But i gather this data using other application. If you get these data then you can combine them with your Query using Merge function in PowerQuery and you will get user name.
You can find some details about hidden User lists on SharePoint under following links:
http://zimmergren.net/technical/sharepoints-hidden-user-list-user-information-list
Looks like the column in SharePoint is a Lookup column and it is putting the ID of another list's items, which is correct. Can you post the column definitions that you have in the SharePoint list?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.