Forum Discussion

dibya1982's avatar
dibya1982
Regular Visitor
9 years ago

Issues connecting to sharepoint

I am getting error while connecting sharepoint to Power BI. Is it  ssue with authorisation? But I checked my authorisation working fine iwhen connecting to sharepoint. Do I need to changeany settings in power BI to access the sharepoint. Please note the sharepoint is on premise and I am trying to connect to it by Power BI. I have installed Power BI in local.

Please throw a light on the issue how to resolve it.Thanks

Issue:-

7 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    If you have Sharepoint on premise, then it would not be visible to Power BI unless there is a gateway setup.  Do you have a Gateway?  

    • dibya1982's avatar
      dibya1982
      Regular Visitor
      9 years ago

      Thanks for your reply. I am using Power BI Desktop version and trying to connect on premise sharepoint. It is saying authorisation issue though I have checked I have full control on the sharepoint site.

       

      Do I still need to set gateway and if so ccould you pls let me know the steps to do that.

       

      Thanks

    • dibya1982's avatar
      dibya1982
      Regular Visitor
      9 years ago

      Thanks for your reply. I am using Power BI Desktop version and trying to connect on premise sharepoint. It is saying authorisation issue though I have checked I have full control on the sharepoint site.

       

      Do I still need to set gateway and if so ccould you pls let me know the steps to do that.

       

      Thanks

      • MattAllington's avatar
        MattAllington
        Community Champion
        9 years ago

        No, if you are using Power BI Desktop from your PC and you are on the company network then you don't need a gateway.  Try File\Options and Settings\Data Source settings.  If you see credentials for Sharepoint, then delete them and try again.