Forum Discussion
Get Full SharePoint List Column Entries
llhanley,
"I want to be able to get the values in this list live "
When you add new values in the choice column, you can click "Refresh" in Power BI Desktop to bring new values.
" I want to do some sub-grouping of the animals by size and type, such as in the table below. I don't want to create this lookup in SharePoint because they don't play nicely with much"
How about you create a relationship using the Animal field between your orginal table and the group table?
Regards,
Lydia
I need all of the values that could be chosen in the Animals column in SharePoint. What I am getting in Power BI is just the data that is intered into the list, not what is behind the list.
I don't want to create a separate table of Animals in Power BI that has to be edited every time someone updates the column choices in SharePoint.
e.g., Someone adds Bison, Elk, Lynx, Frog and Fish s to the Animals column. If I don't have a way to capture those changes programmatically in Power BI, my correlation table will break because those values have to be added in Power BI manually. I'd like to eliminate as much manual data entry as possible.