Sensitivity Label in Excel causes refresh error ( Data source error ) in Power BI Service

[Ali_Shakh]

Hi all!

I've created a report in Power BI Desktop using various sources (all in Excel file, but with different connection properties e.g. from Web or Sharepoint Folder),

A main source for the report are Excel files sent daily to Outlook automatically and a Flow saves them into a Sharepoint Folder.

The report itself works fine, and updates fine in Desktop, but as soon as I publish the report to the Service, refresh option stops working and returns an error that data is corrupted

It took me a while to realize (trial and errors) that the issue is in Sensitivity Label of Excel files I received,

as soon as I open them, choose a label and save a file everything works fine.

Opening each file manually and selecting a label isn't an option (the whole idea of this report was to automate everything).

I tried to fool Power BI doing the following =>
in PQ before "Invoke Custom Function" I made a Sorting, so when the function runs and takes a first file (which I openned and selected a label) as a parameter for others the whole refresh issue will disapear, but...
as you can see, in that case only those that had labes are openned properly, other files have errors 

so, does anyone know how to solve this problem?

[Ali_Shakh · Accepted solution]

UPD:
after some trial and error I figured out the workaround, just replaced all Excel files with CSV and now all is good, it's kinda weird that there is no solution for Excel