Forum Discussion
Can't refresh dataset with merged table from different data sources (incompatible credentials?)
Community ChampionOk I see.
Before appending the 2 Queries did you make sure that Names, Format, Number of columns... are the same in both Tables? In Power query did you check if all Applied Steps in both tables and in the Appended one that the Query folding is not greyed out?
It seems more like there is an incompatibility format somewhere.
Since you are testing go by appending one column at once and see how it works out.
Let me know please.
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
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.
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.