Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

problems using SharePoint.Tables(siteURL) to schedule a data refresh

Hello Everyone,  This being my first post ever,  please be kind...   I have recently started using Powerbi to report on data collected using project 365 online.  I have been able to successfully ...
Need Help
samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
6 years ago

Hmmmm, try editing the url part to be the actual url you are wanting to query:

 

let
Source = SharePoint.Tables("http://xxx.co.nz/sites/projects", [yyy = 999]),

in

Source

 

 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

It has to be the site. The Navigation step actually loads the table/list samdthompson 
I've not tested specifically with SharePoint.Tables, but SharePoint.Contents and SharePoint.Files both error out unless the URL is strictly the top level URL for the site.

  • samdthompson's avatar
    samdthompson
    Icon for Memorable Member rankMemorable Member
    6 years ago

    edhans correct, you can however just leave out the first line of code. My solution is one that I am currently using and I know it works. I have anonymised the URL etc.

     

     

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Interesting samdthompson

      If I connect with anything but the standard URL that has the tenant and site name, I either get

      or the OK button is disabled telling me I need to shorten the URL to just the site.

      This is SharePoint online from Office 365. I am not sure how it works in the case of SharePoint on prem.