There are probably 1000+ better workarounds, but here’s my situation.
I need to connect SharePoint Lists to Power BI (which is pretty easy). However, I have a field on the list called Owner of Issue, a Person field pulling from Outlook.
Power BI cannot read this name and instead assigns a number in its place.
What would you suggest as a workaround for this? Is there a way to create a field hidden on the list that changes this to text? I don’t want to remove the Outlook element as I have conditions built of this already.
If I brought this in as text, Salesforce would read it, and I could use it in my reporting.