Forum Discussion

Anonymous

Not applicable

5 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 ...

Memorable Member

5 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
Community Champion
5 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
  Memorable Member
  5 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
    Community Champion
    5 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.
Anonymous
Not applicable
5 years ago
Hi samdthompson,
what is the [YYY=999] represent in your solution ? I assume that YYY is a variable and that 999 represents the completed URL?
Does this work for you?

Thanks
SEK
- samdthompson
  Memorable Member
  5 years ago
  no no, it was just ananomising the data is all