Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

Sharepoint Excel file refreshes in Desktop; errors in service refresh "File contains corrupted data"

I have a Sharepoint Excel file, which I'm connecting to via this method:  https://www.biinsight.com/quick-tips-connecting-to-excel-files-stored-in-sharepoint-online-from-power-bi-desktop/ It wo...
  • mmace1's avatar
    3 years ago

    Opening the Sharepoint Excel file in desktop, then going to File > Info > Check for Issues (and accepting the changes) seems to have fixed it. 

    Something about custom XML - not really sure what that was about (though I suspect it's the Templify software we use), but not sure at all.