Forum Discussion

Scooby-Doo's avatar
Scooby-Doo
New Member
7 hours ago

Data not updating

I've set up a ticket system on SharePoint which feeds into my Power BI. The visuals are not updating, I've done a manual refresh, refreshed the visuals and nothing changes. If anyone can lend any assistance that would be greatly appreciated. I've reestablished the connection and nothing changes.

3 Replies

  • Are you using a SharePoint List or an Excel file on SharePoint?

    I'd check if the new tickets are showing up in Power Query first. If they're there but not in the report, at least you know the SharePoint connection is working.

    Also, are you refreshing in Desktop or Power BI Service? If it's the Service, have a look at the semantic model's refresh history. Refreshing the visuals alone won't bring in new data.

  • Hi Scooby-Doo​ 

    Can you also make sure that you have clicked on the reset to default button? Because sometimes what I have found is people have put a filter on and that is why it appears that the data is not updating. Due to the cause of a filter.

  • Adding onto others suggestions:

    Try GilbertQ​ 'reset to default'.  The caching of old data is common.  If that doesn't work, there is a refresh data icon nearby, sometimes thats needed to tell the browser to check back with the model for changes.

    You've mentioned SharePoint.  Does your SharePoint list use check in / check out?  If so, do you use Major and Minor versions?  If so, ensure your changes have been checked in as a major version. 

    Ger_Vi88​ suggestion of looking at the data within Power Query is an excellent idea.  Do the rows exist in the source for your query?  If yes, then the problem is in your model. If no, then the problem is on the SharePoint side.

    Still in Power Query, right click on the table that is supposed to contain the data.  Does the option "Include in Report Refresh" have a tick next to it?  If it doesn't, click it and try again.

    If none of the above is working, start checking that you haven't made some small hard to spot mistake. For example does your report connect to a DEV instance of SharePoint but you've made changed to the PROD version of SharePoint.  Did you simply forget to switch environments.