Forum Discussion
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
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)
