I wanted to create a survey (forms) and access the data (excel) in PowerBI.
I'm finding that if i follow the instructions for creating a form on OneDrive, the connection to the data from powerBI isn't updating. I found that I have to manually go into the excel spreadsheet on OneDrive for the spreadsheet to update, and then the powerBI data will update. Does anybody know if there is a delay I'm being unreasonably impatient about for the data to be updated from a form to it's corresponding excel on OneDrive or is this expected? How can i get the data to be instant & live.