Forum Discussion

aktripathi2506's avatar
aktripathi2506
Icon for Helper IV rankHelper IV
10 years ago

Poor Power BI Performance with Inner Join in MS Access tables (10 rows per minutes)

Hi,   My intention is to inner join two tables from MS Access database. When I do left or right join then it work ok but whenever I merge tables with inner then it is very very slow.   Just want...
Need Help
pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

aktripathi2506, It's interesting that only inner join is slow. Are you by any chance joining on non-key columns? Also, if you right click on the merged table step, is "View Native Query" enabled? (If so, the query is been executed on the source, otherwise, there maybe an inefficiency that the mashup engine is performing the join locally)

 

Depending on your scenario, you can also try loading the tables without joining them, and then define a relationship in the reports view.