Forum Discussion

aaron001's avatar
aaron001
Copper Contributor
Oct 14, 2021

Some SharePoint Lists are missing Integrate > Power BI > Visualize this list option.

We have a SharePoint Classic Site which has lists that for some reason don't have the Integrate > Power BI > Visualize this list option. Some lists are ok but others don't have the option. The Lists without the option can still be connected to by Power BI via Power BI directly but the inconsistency is annoying and makes it hard to get widespread adoption for Power BI against SharePoint lists.

 

Looking at the difference between the lists I can't see anything that stands out and all Sites and Lists use the new modern interface. Searching the internet produces very little other than a blog from Microsoft when initially releasing the feature as a preview saying that the feature would be blocked during the preview if it was incompatible with existing lists.

 

Any clues as to how we can get our existing lists supported for Power BI visualization?

 

Thanks

 

Lists
SharePoint Online
  • TheoX84's avatar
    TheoX84
    Copper Contributor
    Jun 27, 2023

    aaron001 I am facing the same issue. I created a list from an excel file, and initially I could see the PowerBi feature under Integrate. However, I did several changes to the list(added some dro-down field options etc.) and now I cannot see the integration with PowerBi. Not sure if my editing is responsible. What I noticed was that, when I opened the list in Sharepoint, I was able to see the PowerBi plugin under the Integrate menu. 

    Don't ask me why.... just thought I share with you. 

    Cheers

     

  • petewood1979's avatar
    petewood1979
    Copper Contributor
    May 30, 2023

    Did anyone find a solution to this? i have the same issue, started the list from scratch without using a template aaron001 

  • jasonf2190's avatar
    jasonf2190
    Copper Contributor
    Jan 05, 2023

    was this ever resolved?  I'm also running into the same issue where I don't see the integrate option in one list but see it on another.  I'm also trying to allow the integration function on my sharepoint list. aaron001 

  • jcgonzalezmartin's avatar
    jcgonzalezmartin
    MVP
    Oct 15, 2021
    Hi!
    Do you know if those lists where created with a "legacy" template? That could be the reason why you don't see the integrate option.
    • jasonf2190's avatar
      jasonf2190
      Copper Contributor
      Jan 05, 2023
      how do you know which template was used? I created a new sharepoint list recently and it also does not have the "integrate" drop down option

Resources