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
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Double checking this

Snowflake doesn't need a Gateway connection, why did you map it in there? couldn't it be that the problem?

cjarvis's avatar
cjarvis
Frequent Visitor
2 years ago

For security, my company has a private / direct connection to Snowflake. We cannot use a cloud connection.

I have tried to set up a cloud connection like this:


Settings the credentials fails with this error:


I really need to point out that, without the table merge, this report retrieves data successfully from Snowflake. The problem is not connecting to Snowflake. The problem is the Power BI Service getting hung up on an irrelevant concern about Teradata and Snowflake having different sets of supported credential types. The service can query data from both data sources, even in the same file.