SQL Server database Advanced options

[Jackofall]

I use Import +SQL statement to run code that I use in a SSRS-report. I do not seem to get any difference in my Power BI report regardless of any combo of these three settings.

Have any of you any documentation on this? I have failed to find anything.

[v-yulgu-msft · Accepted solution]

Hi @Jackofall,

"Include relationship columns"

Suppose there is a tableA with relationship to tableB, when connecting to database if you check 'Include Relationship Columns' then under Navigator window when you click 'Select related Tables' it will automatically pick tableB. Otherwise, it will not pick tableB when you click 'Select related tables'.

"Navigate using ful hierarchy"

If enable this option, you can drill into the schema you're interested in. Please see below screenshots to get the difference.

"Enable SQL Server Failover support"

For this option, you can refer to this thread: SQL Query new advanced setting: "enable sql server failover support"

Best regards,

Yuliana Gu

[Jackofall]

Thanks a bunch.

Since I use a prepared SQL-code to do my joins and filter out what I am interested in, none of those check boxes apply to me right now. However it is very good for me to know in the future.

Have the best of days.