Forum Discussion

tharveen's avatar
tharveen
New Member
5 years ago

PWA oData Risks table (sharepoint list) not showing additional column in PBI

Hi There,   In my PWA environment, I am using risk registers (SharePoint list). Recently I have added an additional column in the risk register. However, in the PBI data feed, these are not being s...
Need Help
Show and Tell
ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. Be sure to review your Power Query steps to check if there is a step "selecting columns or reducing them". The preview of the Query Editor always shows cache in the first view. After checking steps, try refreshing the whole pbix and check if you can see the additional column.

I hope that helps,

  • tharveen's avatar
    tharveen
    New Member
    5 years ago

    Hi there, 

     

    Thank you for responding to my question. I just removed  it and still not see the columns :

     

     

     

    So i did remove the navigation from the panel and saw this :

     

    So i clicked on the risk table :

     

     

     

    Also saw this :

     

     

    Any suggestion?

     

    Also i have not seen these arrows in a column before? what do they mean?

     

    • ibarrau's avatar
      ibarrau
      Super User
      5 years ago

      Interesting. I thought it would appear once you delete navigation and navigate back again. I'm not sure about those arrows in your last picture. Those usually expand rows or columns depending on how you build your source (sharepoint list). You can check if those are keeping the missing column.
      Have you tried a whole refresh outside of the query editor in power bi desktop? (that is usually what I do when I add a new column in source and publish back again)

      Regards,