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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
beispielwiese
New Member

In excel: how-to join external tables without importing to excel

‎07-07-2024 11:46 PM

Hi, 

I have to analyse (in many ways) 2 external tables (accdb) that are needed to be joined first. Unfortunately they are so long that it's not an option to import them in the excel file. 

As an alternative I could join the 2 tables within the accdb but still, the outcome would be to be big to be imported to excel and then being analysed there. 

Could you anyone give me a clue on which direction I need to look for a solution? I really want to do the analysis in excel because of the many ways to create nice management friendly charts there.

Thanks for helping out!

 

 

Labels:
Message 1 of 2
168 Views
0
1 ACCEPTED SOLUTION
dufoq3
Super User
Super User

‎07-08-2024 05:39 AM

Hi @beispielwiese,

  • import both tables into PowerQuery
  • do necessary transformations
  • load both table into PowerPivot
  • create relationship in PowerPivot
  • create measujes you want
  • create charts or tables based od PowerPivot Source

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

Message 2 of 2
117 Views
1 REPLY 1
dufoq3
Super User
Super User

‎07-08-2024 05:39 AM

Hi @beispielwiese,

  • import both tables into PowerQuery
  • do necessary transformations
  • load both table into PowerPivot
  • create relationship in PowerPivot
  • create measujes you want
  • create charts or tables based od PowerPivot Source

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 2 of 2
118 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All