in Customer Insights Data sources , we need some manipulation on data source URL in order to create power query connection designating to right files/folders.
(Prerequisite:Create a share point site and respective folder structure, please put your file in designated location)
mapped URL should be as follows(remove all guids etc. map it as following.
mapped URL -
similar step would work for .csv files too
Check out these options if you are still facing
issue:
- Changing Authentication
kind' from 'Organizational account' and enter the credentials see if it
works?
- Issue could be with the
file path – try this :
To
find the right address in an easy way, open the excel in your desktop app,
go to File, select Info tab, and you will find an option for copying the
path "Copy path" button. Click that button, and remove the
“?web=1” value in the end.
