Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago

Sharepoint data connect

Hi everybody !

 

I just need to connect my Excel table from a Sharepoint link written like that : http://sps/sites/AAA/ZZZ/EEE.aspx

 

It is present like this and my excel is just the file surrounded :

 

 

When I enter my link (without .aspx), I have an error like this :

 

 In fact, I try to enter a reduced link for example with the previous folder, and when I success to connect I see nothing... When I arrive on the a connected panel (Anonymous,Window..) nothing work.

 

I try Sharepoint file, Sharepoint list, Sharepoint list online but unsuccessful..

 

Does anybody can illuminate me on my problem please ?

 

Thanks

Best regards

DavidB023

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi DavidB023, See if you can by using the Web data source type in the gateway connection to the SharePoint URL for the Excel file in the Power BI web service portal.

     

     I have been able to have this setup working previously. Also, by looking at your URL you shouldn't be using the .aspx in your data query. The Gateway connection and the query should instead be referencing the file in the SharePoint library i.e. http://site/Library/file.xlsx

     

    There might be another way to setup this connection, however, this was working for my environment.

    • DavidB023's avatar
      DavidB023
      Helper III
      8 years ago

       

      Anonymousv-piga-msft

       

      Thanks for your answers, I work with Power BI Desktop.

       

      So I try methods you said but I have a little problem. When I enter my url (so without subfolders), Power Bi Desktop launch it and I arrive on a dialog box but nothing appear.

       

       

      Sometimes, I arrived on that when I try other thing like Web source but my login doesn't work

       

       

       

       

      Concerning my URL, the sharepoint which I want is always in .aspx, could it be a problem or is it normal ?

       

      Moreover, my Sharepoint source has several folders but I can't imagine that I can't load everything and load what I want.

       

      Sorry but it's my first time with a Sharepoint so my first with Sharepoint and Power BI...

       

       

       

      I don't really understant what Odata is but I'm sure I can load my Sharepoint without it.

       

      Thanks

      Best regards

      DavidB023

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi David, 

        I guess you've find how to resolve this by now? I am encountering the same issue... Can you share how you were able to bypass those problems?

        Thanks!