Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there. I've seen this posted a few times now and cannot find an answer which resolves my issues.
My Power Bi report online will not update unless I perform a manual refresh from the Desktop App and then re-Publish the report to the workspace.
My data source is a SharePoint list. In Desktop, I have imported the data source (rather than selected "visualise this in PowerBI" from the list). I have then created my report and published online to my workspace. When users update the SharePoint list, then the PowerBI report should update - but it never does. It is always showing old data. Whenever I perform a manual refresh in Dekstop and then re-publish, it updates the online report just fine (so there is no issue/errors with the data refresh).
I have done attempted three things which have not helped:
Even clicking the "refresh visuals" button on the report in PowerBi online does nothing. Why is it so hard to get the report visuals to update based on what the SharePoint list looks like? At this stage, I'd even take an hourly or even daily update!! As it stands, the only way I can update PowerBI online is t refresh the data-set in the desktop app manually and re-publish each time? I have to do this many times a day, just so the users can see the latest data in the report.
I'd be grateful for some help. I can provide screenshots if required.
Hi @FarmingBA
As a test, create a new, simple report with the same SharePoint list as a data source and publish it to see if the issue persists. This can help isolate whether the problem is with the specific report or the data source connection.
This might lead you to isolate and find out the issue.
I never did sadly. I only need the reports to be updated 2-3 times a week, so I do it manually. It's not ideal. Please do respond on here if you ever find a fix. My busines has just had a new BI Developer join, so when they are settled in I will raise this with them. I will also respond on here if I find a fix.
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |