Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

Disable automatic detection of relationships between tables

‎03-21-2016 12:04 PM

How to disable automatic detection of relationships between tables when the data load?

Labels:
Message 1 of 3
25,909 Views
1 ACCEPTED SOLUTION
pqian
Microsoft Employee
Microsoft Employee
In response to arify

‎03-21-2016 03:46 PM

File->Options->Current File->Data Load->Relationships

 

Turn off "Autodetect new relationship after data is loaded"

View solution in original post

Message 3 of 3
31,015 Views
2 REPLIES 2
arify
Microsoft Employee
Microsoft Employee

‎03-21-2016 12:15 PM

Is your datasource a relational database? In the option record you can specify [CreateNavigationProperties = false]

 

Something like this: Sql.Database(server, database, [CreateNavigationProperties = false])

Message 2 of 3
25,901 Views
pqian
Microsoft Employee
Microsoft Employee
In response to arify

‎03-21-2016 03:46 PM

File->Options->Current File->Data Load->Relationships

 

Turn off "Autodetect new relationship after data is loaded"

Message 3 of 3
31,016 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

View All