refresh BI dataset upon powerapps

[mrothschild]

What's the most efficient way of getting data input into PowerApps via the integrated visual to refresh in PowerBI?

I'm relatively new to both BI and PowerApps, and have never used Flow, so I think I may need to integrate all 3. 

I have imported the PowerApps custom visual from the Marketplace into my PowerBI.  

The PowerApps populates an Excel Spreadsheet with a few metrics, e.g., 

1. Acquisition Cost
2. Rent
3. Loan Amount
4. Interest Rate

PowerApps saves into the spreadsheet and then is linked to a calculated table in PowerBI.  The PowerBI table does most of the calculation for the BI visuals.  

So when I change the data in PowerApps, I'm trying to figure out how to most readily save it to the external spreadsheet and then update/refresh my BI?

Thanks

** Update **

From this video, looks like it may not be possible to do unless my spreadsheet is uploaded to OneDrive (even if it's in a cloud software, like Dropbox or GoogleDrive)?

Once data is in OneDrive:

http://blog.pragmaticworks.com/power-bi-custom-visuals-powerapps 

[v-chuncz-msft]

@mrothschild ,

You may take a look at Limitations of the PowerApps custom visual.

[mrothschild]

I understand I need to do a manual refresh.  My file that Powerapps is saving to is a Google Docs spreadsheet.  From the video I linked in the above post, it seems possible to execute a manual refresh if the file is saved on OneDrive.  Does it only work on OneDrive and not on Google Docs?