Forum Discussion

Anonymous's avatar
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 ...
Need Help
samdthompson's avatar
samdthompson
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

 

 

Anonymous's avatar
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's avatar
    samdthompson
    Memorable Member
    5 years ago

    no no, it was just ananomising the data is all