Forum Discussion
Can't refresh dataset with merged table from different data sources (incompatible credentials?)
On the gateway front - this is not my first rodeo. We have on-prem gateways set up - both data sources have connections available on the same gateway cluster.
The screenshot below shows that the credentials for the two data sources are set up and are valid.
The "Some credentials..." warning is not applicable because I have proven that the gateway connection works for both data sources in other Power BI reports. In fact, I can load queries from both sources in the one file if the tables are not combined. i.e. These data sources both work independently and in the same file. The issue here is that an error appears when the data tables are combined.
For example, here is information from a different Power BI file that queries both Teradata and Snowflake.
Two queries are in this file - note that the two queries are not combined in this case.
The dataset can be refreshed without error in the Power BI Service.
The report is linked to the same gateway connections as the one that has the error.
Here is a screenshot of the credentials section of the dataset settings page for this other file. Note the same warning about credentials but this dataset refreshes without issue.
Community ChampionDouble checking this
Snowflake doesn't need a Gateway connection, why did you map it in there? couldn't it be that the problem?
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.