cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tescobar Frequent Visitor
Frequent Visitor

Missing Data when Appending

I am having issues appending two data files together. Once I have appended the files, certain columns are missing data. It goes from showing data to just being blank, in different spots throughout the column.

 

I have read other suggestions to this issue and none have worked for me. I have the October 2018 version of Power BI Desktop. I do not use gateways, nor do I want to.

 

Any help would be much appreciated. Thank youNeed Help.JPGas you can see P2019_09 is just missing data and does not show any amounts, even if it were to be 0.

9 REPLIES 9
Super User
Super User

Re: Missing Data when Appending

With your 2 different tables.  Do both tables have that column?  Usually you get the result you have described when only one of the tables has that particular column.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


tescobar Frequent Visitor
Frequent Visitor

Re: Missing Data when Appending

Yes, both tables do have that column. Its interesting, because the data typically disappears when there should be a value other then 0. 

Super User
Super User

Re: Missing Data when Appending

Post some data files and hopefully someone can take a look at it.  My organisations security prevents me from doing so.  Hopefully by posting the data, someone can reproduce the issue and see the cause.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


tescobar Frequent Visitor
Frequent Visitor

Re: Missing Data when Appending

Unfortunately, I am not able to post the data files I am using. Thanks for you input though!!

Highlighted
Community Support Team
Community Support Team

Re: Missing Data when Appending

Hi @tescobar,

 

Could you please share your M code in power query to me. Did you take other steps? Also you can crete a support ticket for help here.

 

https://powerbi.microsoft.com/en-us/support/

 

Support Ticket.gif

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tescobar Frequent Visitor
Frequent Visitor

Re: Missing Data when Appending

I am not using an M code for these columns. They are hard coded from the excel file that I uploaded into Power BI. I have tried to do a support ticket, but it says I need to be a Pro User. I had put in a request for Power BI to call me on Friday so I am waiting for that as well.

Community Support Team
Community Support Team

Re: Missing Data when Appending

Hi @tescobar,

 

I mean the code in the advanced editor.

 

2.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tescobar Frequent Visitor
Frequent Visitor

Re: Missing Data when Appending

Here it is! 

 

let
Source = Excel.Workbook(File.Contents("C:\Users\tescobar\Documents\LinkedIn\PowerBI Append\LSS\LSS Consolidated.xlsx"), null, true),
PowerBI_Sheet = Source{[Item="PowerBI",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(PowerBI_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"LEDGER_NAME", type text}, {"BATCH_SOURCE", type text}, {"INVOICE_DATE", type date}, {"INVOICE_NUMBER", Int64.Type}, {"INV_LINE_NUM", Int64.Type}, {"CONTRACT_NUMBER", type text}, {"CONTRACT_ORDER_NUMBER", type text}, {"SIGNED_DATE", type date}, {"BILL_TO_CUSTOMER", type text}, {"BILL_TO_CUSTOMER_ALT", type any}, {"BILL_COUNTRY", type text}, {"BILL_TO_GAM_FLAG", type any}, {"SHIP_TO_CUSTOMER", type text}, {"SHIP_TO_CUSTOMER_ALT", type any}, {"SHIP_COUNTRY", type text}, {"SHIP_TO_GAM_FLAG", type any}, {"PROD_ID", Int64.Type}, {"PRODUCT_FAMILY", type text}, {"LINE_START_DATE", type date}, {"LINE_END_DATE", type date}, {"INVOICE_CURRENCY_CODE", type text}, {"JE_LINE_DESC", type any}, {"ITEM_NUM", type text}, {"ACCOUNTING_RULE", type text}, {"BILLED_FROM", type date}, {"BILLED_TO", type date}, {"SEGMENT3", Int64.Type}, {"ACCOUNT_DESC", type text}, {"CURRENCY_CONVERSION_RATE", type number}, {"SUBSCR_PARTY_NAME", type text}, {"AGENCY_PARTY_NUMBER", type any}, {"AGENCY_PARTY_NAME", type any}, {"ORDER_TYPE", type text}, {"PAYMENT_TERMS", type text}, {"INVOICE_PAID_STATUS", type text}, {"SFDC_ORDER_TYPE", type text}, {"SFDC_CLOSE_DATE", type any}, {"BILLING_FREQ", type text}, {"BILLTO_CUSTOMER_SEGMENT", type text}, {"SHIPTO_CUSTOMER_SEGMENT", type text}, {"REGION", type text}, {"REGION_SHIPTO_COUNTRY", type text}, {"REGION_BILLTO_COUNTRY", type text}, {"AGENCY_DISCOUNT", type any}, {"INVOICE_AMOUNT", type number}, {"P2017_07", Int64.Type}, {"P2017_08", Int64.Type}, {"P2017_09", Int64.Type}, {"P2017_10", Int64.Type}, {"P2017_11", Int64.Type}, {"P2017_12", Int64.Type}, {"P2018_01", Int64.Type}, {"P2018_02", Int64.Type}, {"P2018_03", Int64.Type}, {"P2018_04", Int64.Type}, {"P2018_05", Int64.Type}, {"P2018_06", Int64.Type}, {"P2018_07", Int64.Type}, {"P2018_08", Int64.Type}, {"P2018_09", type number}, {"Total Billings", type number}, {"MFST CY/PY", type text}, {"LNKD CY/PY", type text}}),
#"Appended Query" = Table.Combine({#"Changed Type", #"LSS WF 07/17-06/18"})
in
#"Appended Query"

 

Thanks,

Taylor

ash1234 Frequent Visitor
Frequent Visitor

Re: Missing Data when Appending

Hello,

 

Is there a solution for this? I am having the same issue.