I have designed a report in Power BI desktop (Version: 2.65.5313.621 64-bit (December 2018))
My data source is a SharePoint online list. My goal is to automatically refresh the dataset of my report when a new item is created in my SharePoint list. I have created a custom connector in Microsoft Flow who's intent is to refresh my dataset in app.powerbi.com when a new item is created in the SharePoint list. I then created a Flow rule to use this custom connector when a new item is created in SharePoint, the Flow also sends a mobile notification. All of this works as expected. I can verify the dataset is refreshing by going to my dataset settings and refresh history. The refresh history is accurate and inline when I create new SharePoint items. I've shared this report by Publishing it to Web and then sharing the URL link for the report. When accessing the URL link, it is displaying an older set of data and not the most recent set of data even though the data refresh stamp is accurate. I have tried disabling the cache, clearing the cache, and re-creating the report. I am experiencing the same behavior. I am hoping someone can help me with this problem or at least steer me in the right direction to a possible solution.