Sorry, had a typo in my response above. Just to confirm, the data does not need to be public for analyzing it directly in power bi 
As for monitoring surveys, you could look into setting up e-mail notifications whenever there is a new submission (instructions also available on the page above). That way you will at least know when there is something to refresh. All the best, and good luck!
