Forum Discussion
Advocate IImport Excel template to Synapse, populate and push to Teams/Sharepoint
Hi AbiNyk,
I suggest you use a Python Notebook in Synapse and use the sharepoint API to upload files to the sharepoint site.
Here is an example of a Python script to upload an Excel file:
https://stackoverflow.com/questions/70574450/upload-file-to-sharepoint-using-api-postman#answer-78380860
First, you should get the right access token, preferrably with an app registration and access to the sharepoint site. This is how you receive the access token in sharepoint:
https://stackoverflow.com/questions/75795486/how-can-i-get-an-access-token-using-msal-in-python#answer-75800949
Advocate IIts not Fabric but Azure Synapse Analytics
Hi AbiNyk,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
In addition, since your requirement is more related to azure synapse analytics, you can also post this to azure forum to get better support:
Azure Synapse Analytics - Microsoft Community Hub
Regards,
Xiaoxin Sheng