Forum Discussion
If I use an excel file as data source, how to insert data back to this file?
Dears, I have an excel file on SharePoint as the centralized data source. and there will have regular new data filess from teammates, I want to put all the new files in a folder and import them in P...
Hi Anonymous ,
what you need is to use the Power BI alongside with PowerApps.
Check this small example and the community part that is dedicated to the better together.
https://community.powerbi.com/t5/Power-Platform-Integrations/bd-p/pbi_pp_integrations
MFelix
Super User
Super UserHi Anonymous ,
If your files are all in the same format the best option is to use the sharepoint folder connection.
check the link below with the complete details.
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
If you need further assistance please get back to me.