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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Mimi_Ibrahim
Helper I
Helper I

Write back data source directly in Power Bi using Powerapps

Hello everyone, 

 

I have 66 files which are stored as .xlsx format in the Sharepoint. I have combined all the data using Power BI.  I'm planning to implement a write back to these files from Power BI using Powerapps. I managed to go as far as the gallery screen in Powerapps. However I couldn't connect to the datasource as the files were not detected either using Excel online or Sharepoint. Can you advise if this is possible and what is the best way to deal with it? Thank you.

2 REPLIES 2
amitchandak
Super User
Super User

@Mimi_Ibrahim , Once you add any field and use the edit option on the Power app visual, it should allow you the edit

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-powerapp

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/powerapps-custom-visual

https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

 Hello, I'm not able to proceed further because once I managed to get to Powerapps page, it prompts me to connect to the datasource which I couldn't find. 

 

This is the steps that I have followed:

 

1) Click Powerapps for Power bi

2) Add fields from my powerbi datasource

3) Select the defaut environment

4) Powerapps opened in a new window

5) Select 'Gallery'

6) Gallery box displayed but without values and it prompted me to search for data source which I couldn't search using ExcelOnline or Sharepoint (see below)

Mimi_Ibrahim_0-1709127143662.png

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.