Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

sshweky

Bug with Merging tables

Submitted by Helper III on ‎07-27-2018 12:38 PM

I am loading a table, merging it with another and the data is only loading 1,000 records (there should be 11,597). They are pulling from Access .mdb files and using a Left Outer Join. I ran the query in Access and it works fine. Is there a bug???

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎07-29-2018 07:02 PM

Hi @sshweky,

 

It's a known issue, you can keep an eye on the status of this issue in Support site: 

 

q3.PNG

 

 

Best Regards,
Qiuyun Yu 

JorgenEmborg
Regular Visitor
‎08-07-2018 11:11 PM

Hi,

 

I am still facing this issue in Power BI Desktop - as soon as I add the "Expand columns" step, it only pull 1000 rows from the daabase (in my case, a SQL database).

 

The issue has dissapeared from the Support site?

 

Regards,

Jørgen 

Idea Statuses