Firstly thank you to everyone who has been so helpful with previous posts, this community has provided excellent support.
I have a spreadsheet stored in SharePoint online, I have imported the data into PowerBI desktop from the spreadsheet and created a PowerBI file which has been published to the PowerBI service.
Everything works except that when I make a change in the spreadsheet via sharepoint, it is difficult to see whether or not the data is updating properly in powerBI desktop and service. After the first alteration of the sharepoint spreadsheet, it seemed that the updates were reflected quite clearly when pressing the refresh button in PBI desktop and PBI service.
On all subsequent attempts the modified data does not appear at all on the PBI service or desktop. PBI desktop throws errors that the document isnt a valid worksheet and the refresh button in PBI service doesnt appear to trigger any click events whatsoever. I understand a personal gateway is required for scheduled refresh of on-premise data but sharepoint is a online source which should update and refresh within at most an hour or so of any data alterations.
Should we not expect complete functionality of the sharepoint integration features at this stage? Any help is appreciated.