Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

from Excel to Sharepoint

Good morning, everyone,   I have a problem that I can't find a solution to on the forum, I hope you can help me. I created a dataset in Excel to report on PBI Desktop. In order to allow users to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello,

 

Unfortunately, I can't even go further than connecting the Power BI report to the Sharepoint, it stops at this point

 

 

the pop-up I crossed out a cross doesn't even appear, I'm stuck in the first step when trying to connect to SharePoint.

I tried with 2 different Microsoft accounts on 2 different SharePoint spaces but this doesn't change.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

What is the detailed error message?

 

Could you tell me what url you enter?

(hide the private information, replace them with ****(some words explanation, like my site name)

 

Make sure the contents in SharePoint is available for users to acess, 

In my test, the account log in Power BI is the same for Sharepoint.

 

Best Regards
Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

     

    The URL I use is : https://***group.sharepoint.com/sites/gr******board/

     

    and here is the error message that appear after few seconds, it says :

     

    Connexion impossible

    we encountered an error when trying to connect

    Details : Access to the resource is prohibited

    and  it's the same log in power bi desktop as in SharePoint.

     

     

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      6 years ago

      Hi Anonymous 

      Which connector do you choose?

      In my test, i choose the "sharepoint folder",

      if you are connecting to a sharepoint list, please choose "sharepoint online list" connector.

       

      Clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.

      then re-connect to " https://***group.sharepoint.com/sites" with Power BI Desktop to see if it works.

      Also test with the lastest version.

       

      Some similar threads you could refer to:

      https://community.powerbi.com/t5/Desktop/Sharepoint-Folder-to-Power-Bi-Access-to-the-resource-is/td-p/439763

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

       

      Best Regards
      Maggie

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

        As you said, i deleted all permission, downloaded the last version (Sept.) and i have now this screen poping where I put the URL.

         

        I'll try to connect with the 3 option (and deleting permission between each test) to see which one is the good one.

         

        Thank for your previous answers, I'll edit this message when i'm done whith these tests.

         

        EDIT : It works, deleting permission was the solution. I mark it as solved.

         

        Thank you very much !