Column cannot be pushed to the remote data source and cannot be used in this scenario

We have an issue with publishing Power BI report. We are seeing the error "Column cannot be pushed to the remote data source "

The datasource is a live connection to another dataset, and a dataflow 

Power BI Model:

We have a local model for the another dataset (aRUN)and with some calculated column with positive outcome.

We have then added a dataflow as a secondary data source.

We have then created a relationship between the article number (column Article) in the Dataflow table and the other dataset (column Group Article). (one to many, both files set as a text).

Output: 

Output:

If we try to create a table, it is perfectly working and recognizing the relationship between dataset

aRUN dataset and excel column.

Problem

WE have to create calculations using information coming from the two tables (such as a division, if statement and so on). We cannot do these calculations if the values are not stored in the same table, so we trying to do a VALUELOOKUP to add the column from the range list (and the other excel) into the aRUN dataset.

For example, We tried to:

Vlookup the MOQ from the Range List (that we will later use for an if statement with the arun quantity)

Column = LOOKUPVALUE('Range List'[MinimumOrderQuantityArticle],'Range List'[Article],Arun[group_article])

In every situation,  get this error:

Is there any we we can overcome this limitation?

Thanks,

Tanya.