Autorefresh an Excel file from OneDrive url - without error - though not correct

Hi there

I'm struggling with the autorefresh of a PBIX that's loaded into a PowerBI workspace from OneDrive for Business.

The PBIX has 2 datasources; 

1) Business Central (Local) ODataV4

2) An Excel fil placed in the same onedrive folder as the PBIX

I've connected to the Excelfile from PowerQuery;

https://xxxxx.sharepoint.com/sites/xxxxx/Docs/Budget2020_Sales.xlsx

Connecting and refreshing works all fine in PowerBI desktop.

Now to my problem;

When i import the PBIX file into my PowerBI workspace, all seems fine, untill i hit the "Refresh" button or alternatively, when using a sheduled refresh.

I get no errors at all in return of those refreshes, though the data from my Excelfile seems only partly - and for sure not correct loaded. My visuals that's using data from the Excel-file can not SUM totals, and several - not all - lines are getting a "NaN"-value. 😐

If i'm opening the PIBX file in PowerBI desktop, from the OneDrive for Business that's used in my PowerBI workspace, I can sucessfully refresh the Excel-file;

Connection is done as a Web-url connection in PowerQuery;

= Excel.Workbook(Web.Contents("https://xxxxx.sharepoint.com/sites/xxxxx/Docs/Budget2020_Sales.xlsx"), null, true)

Have anyone of you faced the same issue?