Forum Discussion

TxSteve's avatar
TxSteve
Frequent Visitor
3 years ago

SharePoint - Visualize the List - Created - Not showing current data

I have an out of the box SPO list. The data consists of Created dates from Mar 18, 2021 - Aug 3, 2023. I select Integrate, Power BI, Visualize the list, and it builds a very nice report. However the data displayed is 2021 - 2022. I have removed the Created from the field and added it back, I've tried adding a slicer and forcing it to 2022-2023 as an example, and no data is returned. My list has 3191 items in total. Creating filtered views to show a specific year and then trying to visual the list seems to have no impact on the data range. Why isn't it showing the current year from the Created field?

2 Replies

  • ​As of December 2025, Microsoft officially moved away from that "one-click" integration in favor of the Export to Power BI flow.

     

    The following are the options available now -

    • Export to Power BI directly from SharePoint list
    • Create a report on a SharePoint List in Power BI Desktop
  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    Responsive Resident

    sorry if I’m off, but visualize the list uses a static model that doesn’t refresh newer Created rows, so 2023 never shows. to see current data, load the list with the sharePoint Online List connector or export to Excel and load that.