Forum Discussion
Can't refresh dataset with merged table from different data sources (incompatible credentials?)
Community ChampionYou need to edit credentials for each source in the service through dataset settings, did you do it?
... In what way am I meant to edit the data source settings?
The data loads work perfectly in the Power BI Desktop application. I have credentials for each data source that can access and retrieve the data.
These are the details for the Snowflake data source:
And these are the details for the Teradata source:
- aj1973
Ok, I didn't mean the way you connect in the desktop, even though it looks like you should not connect to snowflake using Windows. Please use Snowflake connection and then you need check ou this here in the service
Also, Terradata DB looks like is Local, therefore you need to install an On-Prem Geatway
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.- aj1973
Ok 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.