Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mrothschild
Continued Contributor
Continued Contributor

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., 

  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 

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@mrothschild ,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.