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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors