Forum Discussion

cjarvis's avatar
cjarvis
Frequent Visitor
2 years ago

Can't refresh dataset with merged table from different data sources (incompatible credentials?)

I have a need to merge tables from two data warehouses. I load a table from Teradata into one (supported credential types: Database, Windows), and another table from Snowflake (supported credential t...
Need Help
cjarvis's avatar
cjarvis
Frequent Visitor
2 years ago

I've seen some conflicting information about query folding - I assume that you mean I should look for "view native query" being available on the context menu...

I've reduced the Snowflake query to selecting the top 10 of a single ID:

 

I've done the same with Teradata:


Both OBJECT_NUMBER columns are text. The merged table is also as simple as I can make it:


Neither of the Snowflake or Teradata "source" steps have "view native query" available, even when "enable folding" is set to TRUE on the Snowflake query. The merged query also doesn't have it available.

Even with this setup, the error still occurs in the Power BI Service.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Ok good I love testing.

Just one last try please. Format both columns of the 2 tables to Numbers and try again. Of course the merged Columns has to be Format Number as well.

  • cjarvis's avatar
    cjarvis
    Frequent Visitor
    2 years ago

    The first few characters of the column are letters, so I needed to remove those before changing the data type - here is the example from the Teradata query.

     

    The column in the merged query became a number by default. The same error resulted.