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
CahabaData's avatar
CahabaData
Icon for Memorable Member rankMemorable Member
9 years ago

It's not clear if your post is really a continuation of the original thread.  It doesn't sound like your data is stored in Microsoft Access. 

 

But in any case I don't quite follow what is your situation in PBI Desktop;  as I understand you have multiple different databases and you'll import data I presume. 

 

Depending on the brand of database one can make a View in that database so that the data set available to PBI is just the data you seek and not the entire table of the database.

 

 

 

 

alm5084's avatar
alm5084
Icon for Helper II rankHelper II
9 years ago

Then I would have to create views for every one of my queries in almost every dataset, as they are all somewhat different.

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable Member
    9 years ago

    in PBI Desktop one can join between tables, not queries as standalone objects in the sense that those are used in the database world. 

     

    It was never quite clear/resolved why the original poster had a slow experience.  It can depend on the record count and strength of the computer but I don't see alot of complaints about slowness specifically due to joins.

     

    still not quite clear your starting data set structure and what you seek, perhaps best to start new thread