include relationship columns option in query editor

[elz]

Hello,
I am using Power BI Desktop, the 32-bit version of the July update (version 2.37.4464.461).

The include relationship columns option that I am referring to, is on the Source step for an Access database.
I can't figure out what it is suppose to do.
I thought it would work like the "select related tables" button on the navigator window, but when testing, the related tables were not imported.

I am hoping that someone can tell me what this option does.

Thank you
Tracy

[ankitpatira]

@elz Basically the way that works is,

I have tableA with relationship to tableB, then when connecting to database if i tick 'Include Relationship Columns' then under Navigator window when I click 'Select related Tables' it will automatically pick tableB but if i have not ticked that option then when you click 'Select related tables' it will not pick tableB.

[elz]

Hi Ankit,
I tried it again. I cleared the Include Relationship columns option for the database in the query editor, then saved the changes and closed the file.

I re-opened the file, went to the navigator window, selected the table, clicked the Select related tables button and a few tables were automatically selected.

My thought was that no tables should be selected, unless the option works differently, with different types of databases. By that I mean, the include option seems to be ignored with an access database. right now, i don't have another type of database, like a sql server database to test with.

I don't know if i did anything wrong along the way.
Thank you
Tracy

[Eric_Zhang]

---

I tried it again. I cleared the Include Relationship columns option for the database in the query editor, then saved the changes and closed the file.

I re-opened the file, went to the navigator window, selected the table, clicked the Select related tables button and a few tables were automatically selected.

---

@elz

I don't see the option "Include Relationship columns" when accessing an Access accdb file.  So I think the option won't affect the "select related table" option when using an Access source. And it seems that "select related table" always works. Regarding other databases that have the option "Include Relationship columns", "select related table" works accordingly.

By the way, may you guide how to clear that option in query editor.

[elz]

hi eric,

i don't have plans to use this option or the select related tables options, as i can't confirm, whether or not they work consistently. i'll stay old school on this one and check the tables i want to import.

your reply of not seeing the include relationship columns option for access accdb files, is exactly what i am referring to when i question whether or not some options work consistently. i do see the option with accdb databases. mine are 32 bit. i don't know if that makes a difference or not. are you access db's 32 or 64 bit?

to me, it would be more useful to have all of these import related options in one place, instead of scattered, especially, since there really isn't any written documentation for all of these options.

i don't understand the last line of your reply, so i don't know if this answers the question or not. i don't use the query editor to import data. i user the get data button. if that doesn't answer your question, please add more info & i will try to give you specifics.

thank you
tracy