Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
111
Views
Topic starter
Hi,
how is it possible to import into Power Pivot data of an excel file located on a OneDrive Sharepoint?
Sharepoint is accessed through corporate network with user and password.
which works fine accessing the file directly on one drive
Thank you
Posted : 07/05/2019 9:15 am
Hi Steffen,
Use Power query, New Query-From Other Sources-From Sharepoint List. You will be able to login after you provide the user and pass after you provide the root URL of your sharepoint site.
The query can be loaded to the data model (Power Pivot).
Posted : 07/05/2019 10:58 am
