Forum Discussion
Helper IVPoor Power BI Performance with Inner Join in MS Access tables (10 rows per minutes)
Helper IVNo opinion or similar situation with anyone.
I checked multiple times, everytime for left or right join it work fast but for inner join it workes very slow I am connecting with Access database and both the tables has around 10 columns and 500,000 and 1,200,700 rows respectively.
- CahabaData
Memorable Member
I cannot say why the inner join would differ than the outer in terms of speed. That remains a mystery. My question is that I do not understand what is slow? A merge query? I don't see a need to do a merge query when using Power BI so that would avoid this slowness perhaps.
Are these two tables importing/imported into Power BI?
- aktripathi2506
I meant: When I do merge query then merging the query in query editor is slow.
at bottom right corner it update how many rows it has loaded so that is how I know it is loading very slow because I have in total millions of rows.
And also when the query get complete in Query editor mode and when we select load and apply, at that time also it takes a lot of time.
For the 2nd question: Why do I need to merge the query:
Like I mentioned in my last reply that I am trying to get the result of a SQL query so that is why I was connecting the tables in the same way. I need a column which can use columns from other tables, I can not do all calculation based on measure.
I wish I could share the data with you but I can not and also creating a sample test data will be difficult.
Power BI has merge query option so I hope they must be having some need behind it.
All the tables are imported from access data base into power BI.
- CahabaData
You do not need to do a Merge Query. Instead just do a join line between the 2 tables - the same as in a database.
Then in a measure/visual you can call the data from the 2 tables together using the RELATED or RELATEDTABLE function / method.
