Search Related tables option in get data

[lakshmi11]

Hi,

There is a option called "Search Related Tables" during data preview mode. Can someone please expain the functionality of this?. 

I have tried using this, but nothing  really happened.

[v-jiascu-msft · Accepted solution]

Hi @lakshmi11,

Did you mean "Select related table" as the picture showed? First select a table, then Power BI will select all the related tables according to the relationship when we click this button. (In the picture, I only selected "DimCustomer". And the data source is Sql Server, so there are relationships exist.)

 

Best Regards!

Dale

[v-jiascu-msft · Accepted solution]

Hi @lakshmi11,

Did you mean "Select related table" as the picture showed? First select a table, then Power BI will select all the related tables according to the relationship when we click this button. (In the picture, I only selected "DimCustomer". And the data source is Sql Server, so there are relationships exist.)

 

Best Regards!

Dale

[v-jiascu-msft · Accepted solution]

Hi @lakshmi11,

Could you please mark the proper answer if it's convenient for you? That will be a help to the others.

Best Regards!
Dale