Forum Discussion

chickyd's avatar
chickyd
New Member
10 years ago

Sharepoint Online Refresh

I've created a report in PBI Desktop which links to Sharepoint Online Sites (excel files). I had originally set the file up with the source pointing to my c: drive so changed the source within the ad...
chickyd's avatar
chickyd
New Member
10 years ago

Thanks for your feedback

 

Greg_Deckler The file is on Sharepoint Online within a Team Site. There are two files pointing at two different Sites but under the same company domain. It's not possible for these to be within One Drive for Business due to the sharing implications.

 

Anonymous The issue I have is that I have spent a lot of time building the reports within PBI desktop and therefore rebuilding from scratch is a huge job which I really would rather avoid. I initially built the file linking to the two files on my c: as I wrongly assumed that as they were within the Sharepoint folder they would automatically link to the cloud versions. My reseach online then led me to change the source in the advanced editor, which when I published online, seems to work for manual refreshs now I've input my credentials. It just seems to be the Scheduled Refresh which is broken. Any ideas?

 

Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi chickyd,

    I made a test with a free account and schedule refresh works as expected. No error message is thrown. Based on my reserach, some persons encounter the similar issue as yours, which is resolved by re-creating the PBIX file and re-publishing it. I would recommend you create a simply report by connecting to SharePoint Online Excel file via Get Data>Web entry and publish the report, then check if the error message still errors.

    Thanks,
    Lydia Zhang