I am able to write python code in a Jupyter notebook inputting credentials and download files from an Enterprise SharePoint site.
But when I try to do this from PySpark in fabric I get forbidden access errors or can’t use a token error.
Anyone know what code I need to use in fabric to pull data from excel and csv files in SharePoint? I know I could use dataflow gen 2 but I want to use the ability to create a table and append/modify within fabric not just be a link from it.