SharePoint Excel-files containing Corrupted Data

[SHS]

Hello,

Yesterday my organization chose the step to upload all our Power BI reports and used data files to SharePoint. At first it seemed quite successful as we able to easily refresh and publish the reports without any issues and considerably quicker than when working on local drives. Now, when I try to refresh either report I get a message that one of the files contains corrupt data. When I have fixed this, I get for the next. I found out that I could just overwrite all the data files on SharePoint with those used in the local drive. But this is becoming quite cumbersome if that is what I need to do everytime. Do one of you know, why this is happening? 

We have 32 data files (not all used for every report) and 12 Power BI reports. The 32 data files varies a lot in file size. Some only contains 8 data cells, whereas others contains multiple columns, rows, and sheets - in here also a lot of formulas. 

Hope you can help as it is driving me crazy. Considering that both are Microsoft products it is expected that it should work.

Best,
SHS

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".