Forum Discussion

AndrewKent's avatar
AndrewKent
Helper I
9 years ago
Solved

Power Query Append Issue

Hi there,   I've noticed a strange issue with Power Query (and I assume the same functionality in Power BI) whereby I have 2 connections loaded in Power Query (both csv files with c15K lines of dat...
Need Help
  • AndrewKent's avatar
    AndrewKent
    9 years ago

    Hi,

     

    haven't been able to recreate this issue either. I have been expereincing multiple issues like this (and connection issues to datasets that were working fine) however restarting Excel seems to clear them up.

     

    Thanks for your help.

     

    Andy

AndrewKent's avatar
AndrewKent
Helper I
9 years ago

Hi,

 

haven't been able to recreate this issue either. I have been expereincing multiple issues like this (and connection issues to datasets that were working fine) however restarting Excel seems to clear them up.

 

Thanks for your help.

 

Andy

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi AndrewKent,

You can mark helpful reply as answer to close this thread. If you get any new issues, feel free to post back.

Thanks,
Lydia Zhang

  • subhotech's avatar
    subhotech
    Regular Visitor
    8 years ago

    Hi ,

     

     I am experiencin similar issues. I have two data sources in Query editor (c connected to SQL Server). All i trying to do is union of both the datasets using the 'Append as New' option in Query Editor.   Source A has 10 records and source B 20 records. Append query is exptected to produce a result set having 20 records including the duplicates. Some records are not present in the New Data Set.   Please Advice !

     

    Regards,

     

  • subhotech's avatar
    subhotech
    Regular Visitor
    8 years ago

    Hi ,

     

    I have two data set in powerBI query editor which are connected to MS Sql Server.  I am trying to union those data sets to create a new dataset having all the records using 'Append as New' functionality.  I can see missing records in the final dataset.  

     

    Source A has 10 records ( example)

    Source B has 20 records ( example) 

    Final Dataset has < 30 records.

     

    Both dataset has same number/order of columns which is necessary for doing union i.e Append in PowerBI. Please Advice!

     

    Regards,