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
edhans's avatar
edhans
Community Champion
5 years ago

SharePoint.Tables is supported, that is a SharePoint List. 
But there are issues with the service and dynamic sources. You may want to read this article, and all related articles it links to to see if you can work through it.

 

If your Lists were consistent, you could manually connect to each and Append - Table.Combine(). But if new lists are constantly getting added with each project, then that wouldn't work, and probably why you went the dynamic route as you did.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Edhans,

 Thankyou for your feedback, I will work though the links you have provided however given the simplicity of the objective there may be a different solution to this problem. With answer to your assumptions you are correct that the subsites are created as required and therefore there is no consistent site. 

Thanks
SEK

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thankyou to all who have contributed thus far with this solution;

    Part A.

    We have achieved mild success, the BI can be scheduled when using the full path thus confirming your advise that the URL needs to be complete for the scheduler to analyse the existance of the site before being scheduled.

     

    Part B. 

     Now I'm stuck trying to "Fake it out" as is the solution recommended.

    Above commented is the example from the linked sites above where in use of web.contents the method has been used to substitute a portion of the URL; This should also be possible where the base of my sharepoint site is the PWA and subsite then would need to be applied as the peramiter. 

    I have changed the value of "siteUrl" above to be the name of the subsite only and used [relativepath="/" & siteURL] as also commented above. however at this stage the substitution is not working and therefore returning a blank set of data.

    Can anyone suggest how this substitution should look ?

     

    Thanks

    SEK