Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Paulyeo11
Impactful Individual
Impactful Individual

Details: "Access to the resource is forbidden."

Hi All

I try to create a new site , i have add membership :-

https://isdnholdings.sharepoint.com/sites/FT_SUP/

I keep getting below error msg.

Paulyeo11_0-1609405708764.png

I also have existing site :-

https://isdnholdings.sharepoint.com/sites/FOLD_TDS_SI/

When i access no error.

where go wrong ?

The reasons i create diff site is because , i seperate site by file type for example GL , AR , INV etc

Paul

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Paulyeo11 ,

 

please try the following

 

  1. Open Power BI Desktop, when you already created visuals use the existing pbix
  2. go to File --> Options and settings --> Data source settings
    Check "Data sources in current file" and "Global permissions", mark any source that points to the new Sharepoint site and hit "Clear Permissions"; be aware that the source might not dissapear
  3. Close the Data source settings dialog
  4. Hit refresh
    Make sure you select "Microsoft Account" when you are getting asked to authenticate
    TomMartens_0-1609406812210.png

Hopefully, this solves the issue you are facing.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

5 REPLIES 5
ShashiSunagar
New Member

Hello, I am still facing an issue with Power BI while accessing Graph API via Odata. I'm able to run https://graph.microsoft.com/v1.0/users and get the data in graph explorer. But when i try to get it in power bi, I get forbidden error. I tried the below approaches but nothing worked for me. Kindly help.

ShashiSunagar_0-1685104415792.png

 

TomMartens
Super User
Super User

Hey @Paulyeo11 ,

 

please try the following

 

  1. Open Power BI Desktop, when you already created visuals use the existing pbix
  2. go to File --> Options and settings --> Data source settings
    Check "Data sources in current file" and "Global permissions", mark any source that points to the new Sharepoint site and hit "Clear Permissions"; be aware that the source might not dissapear
  3. Close the Data source settings dialog
  4. Hit refresh
    Make sure you select "Microsoft Account" when you are getting asked to authenticate
    TomMartens_0-1609406812210.png

Hopefully, this solves the issue you are facing.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom

Your advise is correct and working fine now.

Thank you very much

Paul

Hi Tom

 

Thank you for your sharing.

After reading your reply , i think your approach is when in the past i have already access the sharepoint data , and due to change of PW , then it will help. 

But mine is today i try to add new table to my PBI , i am not able access sharepoint folder.

I can access using local drive. but it is not i want.

I also can access to existing sales invoice folder , by put my supplier raw data there , i can also access , but that is not i want , because later i need to add more table in the same folder.

 

Paul

 

Paul

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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