Dataset refresh error: Native queries aren't supported by this value

[adnankabina]

Hi I have two data source one is coming from big query and one is coming from teradata. I imported both as tableA and tableB and left join with merge option in query editor editor. Left join working fine on desktop and refreshing data when I publish it on service. it gives me erro mesage . 

I am using gateway for Teradata and using my crendential for bigquery on service.  

Error message 

Native queries aren't supported by this value."}

[arvindsingh802 · Accepted solution]

You can follow https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create to get started wit data flow

[arvindsingh802]

Please create two saperate dataflow - 1 for each type of query
use these 2 dataflows as source in your dataset and then apply merge operation in Power Query

[adnankabina]

I didnt get your point. it is one pibx file tableA is teradata and TableB is biqquery  then merge it.  Is dataflow I belive on serivces. I have never used it. can you please explain it