Forum Discussion
Helper IIDataset refresh error: Native queries aren't supported by this value
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."}
You can follow https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create to get started wit data flow
3 Replies
- arvindsingh802
Community Champion
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
adnankabinaI 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