Power BI loads different table than PowerQuery calculates

Hello all,

I am constructing a Power BI dashboard. Most calculations happen in PowerQuery, Power BI is just for the visualisations and some filtering.

My problem arises in the sanity check, where I am checking whether I read all the files with a given name correctly (those files come from a SharePoint). I do this by checking the length of the corresponding queries, that load the data. This check is in two separate queries (the ones above and below the red line, respectively) that I then combine (with Table.Combine).

This is the output of the query “Status_Dateien” within PowerQuery:

correctly calculated table in PowerQuery

That is as expected and correct.

But when I refresh everything and load this table into Power BI (also in combination with Close & Apply), I get this table:

falsely imported table to Power BI

The column names are the same, but it got loaded with different calculations, and without any error messages. The error seems to be in the query above the red line. But why does PowerQuery calculate correctly, and Power BI imports something different?

If I load the table into the dashboard, it’s the false one. So, the error seems to be in the interface between PowerQuery and Power BI.

I searched for this error but only a few people had this problem.

By now I tried clearing the cache, rewriting the queries, and updating Power BI (the Microsoft store shows me no possible update).

Please help me with advice.