Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
pparke
Frequent Visitor

Unable to locate file in Share point as data source

‎03-31-2019 08:48 PM

New to Power BI. 

 

A document has been shared with me in Share Point and it is located in a folder that I do not have permission to access. I can open the document in the link shared with me however, when I attempt to get data via Sharepoint folder/ online or through web, I cannot locate this file.

 

Can anyone advise whether you need permission to use a file you do not have access to the location folder?

 

Thanks in advance

Labels:
Message 1 of 6
1,281 Views
0
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support
In response to pparke

‎04-11-2019 01:59 AM

@pparke ,

 

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/SharePoint-List-Access-to-resource-is-forbidden/td-p/51475

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Message 6 of 6
1,242 Views
0
5 REPLIES 5
parry2k
Super User
Super User

‎03-31-2019 09:06 PM

@pparke  what kind of file is this? Is this excel file you want to use in powerbi?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 6
1,275 Views
0
pparke
Frequent Visitor
In response to parry2k

‎03-31-2019 09:14 PM

Hi @parry2k . Yes, it is an excel file

Message 3 of 6
1,271 Views
0
parry2k
Super User
Super User
In response to pparke

‎03-31-2019 09:18 PM

@pparke great. open the file in local excel copy , not online and get the location of the file to use in powerbi. Read more here on how to connect, although link say "onedrive" but same logic will work for your example.

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 4 of 6
1,269 Views
0
pparke
Frequent Visitor
In response to parry2k

‎03-31-2019 11:12 PM

Thanks @parry2k  When I try this method, I get an error message saying  a'ccess to the resource is forbidden'.

 

 

Message 5 of 6
1,261 Views
0
v-chuncz-msft
Community Support
Community Support
In response to pparke

‎04-11-2019 01:59 AM

@pparke ,

 

You may check if the post below helps.

https://community.powerbi.com/t5/Desktop/SharePoint-List-Access-to-resource-is-forbidden/td-p/51475

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 6 of 6
1,243 Views
0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

View All