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?