Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
@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
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)
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 17 | |
| 13 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 41 | |
| 39 | |
| 38 | |
| 38 |