Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Incomplete Data (Append)

Last Friday there was a notification on https://powerbi.microsoft.com/en-us/support/ regarding an issue with certain customers:   "Customers utilizing specific connectors without using native SQL q...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    I'm still not able to reproduce the issue on my side. Would you please update your Power BI desktop to August version 2.61.5192.541 to see if the issue persists? 

     

    Best Regards,
    Qiuyun Yu 

  • musicbydannyd's avatar
    musicbydannyd
    8 years ago

    Just installed August desktop app AND August on-premises gateway... no more issues.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Cluster: 

Power BI
©Microsoft Corporation 2018. All rights reserved.
Version 13.0.6199.204 
Activity ID df4c312c-bad0-cdf0-b04d-68bcfa22902d 
Time Wed Aug 08 2018 09:16:43 GMT-0400 (Eastern Daylight Time) 
Your data is stored in North Central US (Illinois)

 

 

Do you mean you repeat append queries four time to append these 5 tables, right?

 

 

 

 

 

 

 

 

 

From your description, it looks like the issue happens in Power BI desktop, right? 

It happens on both desktop and web.

 

When you mention "only picks up 1000 rows of each table", do you mean the issue occurs in Query Editor, Data tab or Report tab after apply changes?

It happens on both Data and Report.