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