Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I know that there have ben some posts about the excel from a SharePOint, but no resoluition to my issues. Can anyone explain r show how to upload data from an excel file that lives in a SharePoint? I am going to Get data>Excel>SharePoint but no luck. 😞
To load data from Excel file on Sharepoint, you should go to "Get Data->Sharepoint Folder->Excel file". Or you can try the file URL via Web connection.
Regards,
What part isn't working? Are you getting an error? I tested with an Excel file saved in a SharePoint document library, and went to Get Data -> Excel. In the file selection window, I pasted the link to the document library, minus the /Forms/AllItems.aspx at the end of the link. I was prompted for my network credentials, entered them, and could then select and load data from the Excel file the same as if it were on my Desktop.
Thank you. Now it worked, but now I have a message see attached. But I do not know where to put it on my trausted list. HAs it happened to you?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |