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

Well you should now use the merged query table and its fields to build the report, visuals and KPIs

cjarvis's avatar
cjarvis
Frequent Visitor
2 years ago

No, I still can't use the merged query to build visuals in the report as the online service still returns this error message:

 

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

    You need to edit credentials for each source in the service through dataset settings, did you do it?

    • cjarvis's avatar
      cjarvis
      Frequent Visitor
      2 years ago

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

        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