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

[tanyapammy]

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.

[v-zhengdxu-msft]

Hi @tanyapammy 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@tanyapammy , is this model a combination of direct query and import mode? I doubt this will work. If this pure import mode, it should work

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8