Dataflow showing empty tables in Power Bi desktop

Hi

I have dataflow with in total 10 Entities on a Premium account.

I am having trouble with tables showing data in Dataflow but they are empty in Power Bi Desktop.

All marked with bold shows data in Power BI Desktop.

Entity1: loads and combines .xslx files from a Sharepoint folder. - currently 3 files about 9 mb in size each

Entity:2 Manually entered data

Entity3: load data from Excel sheet in Sharepoint folder and merge with Entity2

Entity4: Use Entity3 as reference and replace values and unpivot

Entity5: Use entity1 as Reference, merge with entity3 and make calculations

Entity6-9: Use entity1 as Reference, merge with entity3 and make calculations - Similar setup as Entity5 but with different calculations

Entity10: Combines Entity5-Entity9 - In Power Bi Desktop it is only showing data from Entity5.

In all entities I can see data in the Dataflow when editing in the Web.

• I have made sure that I have actually refreshed the data in the dataflow after saving.
• I have tried to refresh in Power Bi Desktop
• I have tried to remove permissions to Dataflow in Power BI Desktop and added it again.

I cannot figure why entity6-9 is somehow different from Entity5.

I am not getting any error messsage in either Power BI Desktop or Dataflow.

Can you help out?

Br

Jakob