Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to pull data into power BI desktop through OneDrive

Hi there,

 

I've been trying to get excel data from OneDrive but I've been getting an error stating "Access to the resource is forbidden" though the file was uploaded to the OneDrive by myself and I'm also unable to refresh the dataset which is stored in my teammate's OneDrive.

 

Any help on getting this issue rectified would be helpful.

Need Help

5 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    After test, it has no issues that I am logging in with different accounts in Power BI and One Drive. But when you get data from OneDrive, you must type OneDrive credentials rather than use your Power BI account, please follow the steps below.
    1. Click File->Options and Settings->Data source settings->clear your previous permission.

    2. In Power BI desktop, type the link, please choose the Organizational Account to sign in(because use OneDrive for business, type your Organizational Account of OneDrive here), it will work fine after clicking connect. In this part, if you use windows authentication, it will return the error message, because you current power BI account is not windowns account.

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Even after trying to login to organizational link, pop up comes saying we cannot authenticate you

      • bvdm1980's avatar
        bvdm1980
        Icon for Helper II rankHelper II
        1 year ago

        could it be that you have microsoft authenticator step that is needed from company policy? 

        So it always needs authenticator confirmation, i have the same issue and just was thinking that this might cause the issue. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for the response amitchandak. However, this isn't helping me overcome my problem. I always try to pull the data as it was mentioned in the link you've provided.