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.,
- Acquisition Cost
- Rent
- Loan Amount
- 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
