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
cjarvis's avatar
cjarvis
Frequent Visitor
2 years ago

Hi aj1973,  

Thank you for the suggestion - unfortunately, it did not work. Power BI seems to retain the full data lineage for the merged table. The Power BI Service returned the same error message about authentication types.

By the way, I assume that you mean the tables should be set to not load like this in Power Query Editor:


I should also note that once the tables were set to not load, data from the tables could not longer be used in the report:

 



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: