- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

refresh BI dataset upon powerapps
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You may take a look at Limitations of the PowerApps custom visual.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-16-2024 11:53 PM | |||
09-20-2024 10:11 PM | |||
07-26-2024 03:36 AM | |||
07-13-2023 08:37 AM | |||
06-16-2023 05:26 PM |
User | Count |
---|---|
95 | |
86 | |
85 | |
52 | |
46 |