User Profile
EricParsons
Copper Contributor
Joined Oct 30, 2023
User Widgets
Recent Discussions
SharePoint and Power BI: Field Not Read in BI - Number Assigned Instead
Hello All, 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. Thank you! EricJSON Result is Not Displaying in Gallery or Board View
Hello, I’m struggling with showing a JSON result in any view besides the list view. In the list view, my calculation works fine. It takes the date a machine went down, a formula that continuously calculates against today’s date, and gives me the result I need. However, when I try to change the view, the result isn’t displaying. Help is greatly appreciated. I need to show that value in either the gallery view or the board view. Thank you! Eric
