Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Do not autodetect relationship with index columns

I used the query editor to create several unrelated tables and created an index column for each. When I applied the query and returned to PBI Desktop main screen, a relationship was automatically detected between the columns because they shared a name. This frustrated later efforts to link tables, as certain index columns were not unique. I had to open the 'Manage Relationships' option and delete each relation. Either columns called 'index' should not auto-detect, or each auto-index column should be named with the table name as a prefix/suffix.
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes