Forum Discussion
Importing Access on Power Query
Hello everyone, I would appreciate your help in what I imagine is a simple matter. At work I'm trying to create a dashboard from the database in Access which generates codes and control any ...
I am guessing you have a related table with information which shows up in the child table in the field which has the relationship to the other table. You should import both tables separately (in PQ) and then join them together in Excel's data model so you can use -for example- a pivottable.