Forum Discussion

llhanley's avatar
llhanley
Regular Visitor
8 years ago

Get Full SharePoint List Column Entries

Hi all, I have a SharePoint choice column I want to use for reporting. I need to count actual vs possible for that column. How do I get the values for the possible choices through Power BI without c...
llhanley's avatar
llhanley
Regular Visitor
8 years ago

Here's what I've got.

 

1. A SharePoint list with 26 kinds of animals in it. This list could be updated to include new animals. I want to be able to get the values in this list live so that I'm not creating another table in Power BI that has to be updated separately from the SharePoint List it originated from.

 

 

2. List data that doesn't use all 26 of the values in the list. It may someday, but for now, it doesn't. I want to report on this data in relation to the full list of animals and some sub-grouping items that I note in #3 below.

 

3. 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, and I don't need the rangers to be populating this data anyway. I just need it to report from behind the scenes, so I want to create it from inside Power BI.

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • llhanley's avatar
    llhanley
    Regular Visitor
    8 years ago

    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.