Forum Discussion
Poor Power BI Performance with Inner Join in MS Access tables (10 rows per minutes)
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.
Hi pqian, Thank you for the reply.
"View Native Query" is disabled. Although its good to know that otherwise it will excute on source. Thanks.
If we define only relation between two tables then it doesn't allow us to use other tables column in the formula.
For example if Table 1 has: Id, date, hours, task
Table 2 has: ID, name, salary.Then if I want to create a column in table 1 which needs to use salary then I can not do that. This is just an example. I have a situation where I need to use the column from the 2nd table in formula.
I have 5-6 tables which I need to merge based on different join. Basically I am trying to convert the SQL query result in power BI.
I cannot explain the slowness but it is not clear to me why one would merge related tables, particularly should there be a 1:Many relationship. Making the join line is sufficient for the need to find data that is in both tables in a calculated measure when used with the RELATEDTABLE method/function. One of the benefits of PowerBI is not needing to flatten relational tables.
