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