Forum

GET DATA WITH POWER...
 
Notifications
Clear all

GET DATA WITH POWER QUERY from an excel file or a csv stored in one drive or in sharepoint

4 Posts
3 Users
0 Reactions
128 Views
(@sbaldi)
Posts: 16
Eminent Member
Topic starter
 

Hello,

 

Do you think is possible to do what I write in the topic name? 

A great thank you to everyone could help me with this issue.

 

Stefano

 
Posted : 02/07/2019 4:17 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Stefano,

Yes, you use the From Web connector and the SharePoint file path.

Mynda

 
Posted : 02/07/2019 9:53 pm
(@sbaldi)
Posts: 16
Eminent Member
Topic starter
 

Hello Mynda thanks for your answer.

Unfortunately I try what you suggest but didn't work.

This what I did

--> get data --> from other source --> from web --> I paste the link to the file.

This is the link

https://boomimagestudio.sharepoint.com/:x:/s/boom_finance/Ee4bmf7CPqVBuBud_j4rP0QBSIFFARdUGU8el-Ms10gzeA?e=zsoach

 

Excel told me that the "Access to the resource is forbidden", .

Could you help me with this?

 
Posted : 03/07/2019 1:36 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Stefano,

After you paste the link and choose next, a new dialog should show up: Access Web Content, on the left side you should have 5 authentication options: Anonymous, Basic, windows, Web API and Organizational Account. Choose this last one, and follow the login steps, after that you should be able to access content.

Check also the file properties on sharepoint, make sure it has at least read only permissions set.

 
Posted : 03/07/2019 4:15 pm
Share: