Forum Discussion

JoostttP's avatar
JoostttP
Regular Visitor
9 years ago
Solved

Microsoft Access database nested tables

Hi all,   I have been working with power BI for a week now. I do have experience with Qlik Sense and the advanced modeling of Qlik Sense.   When I import a table from demo database from Access in...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi JoostttP，

    Based on my observation, when loading tables from Access database to Power BI Desktop, Power BI Desktop imports the columns in these tables as well as Object Dependencies of these tables into Query Editor, and Power BI treat the dependencies as new columns of these tables.

    For example, for order table in Access database, there are other 8 objects depending on it, Power BI Desktop puts the 8 objects as additional columns in order table. From my point of perspective, this behavior is proper, Power BI Desktop loads all properties of a table(data and dependencies), it doesn’t ignore dependencies and it makes us easy to select values from related tables. 


    Moreover, if you don’t want to retain these additional columns, you can directly remove these columns in Query Editor of Power BI Desktop or delete the object dependencies of your tables in Access database.




    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi JoostttP，

Based on my observation, when loading tables from Access database to Power BI Desktop, Power BI Desktop imports the columns in these tables as well as Object Dependencies of these tables into Query Editor, and Power BI treat the dependencies as new columns of these tables.

For example, for order table in Access database, there are other 8 objects depending on it, Power BI Desktop puts the 8 objects as additional columns in order table. From my point of perspective, this behavior is proper, Power BI Desktop loads all properties of a table(data and dependencies), it doesn’t ignore dependencies and it makes us easy to select values from related tables. 


Moreover, if you don’t want to retain these additional columns, you can directly remove these columns in Query Editor of Power BI Desktop or delete the object dependencies of your tables in Access database.




Thanks,
Lydia Zhang

  • JoostttP's avatar
    JoostttP
    Regular Visitor
    9 years ago

    Hi Anonymous,

     

    Thank you for your response. I figured it would be something like this. Thank you for your explanation.

     

    What is your opinion on either merging the additional data this way or importing both tables first, and then create a merge based on a shared ID? What would be faster is perfomance you recon?

     

    Thanks,