Disable automatic detection of PowerPivot relationships
A common pattern in PowerPivot/PowerBI development is to create tables with no relationships to other tables. E.g. for storing parameters or for organising Measures.
However, in Excel 2016, we constantly get a yellow warning in the pivot table field list that "relationships between tables may be needed". This message reappears, even when I close the warning.
This behavious is really annoying and makes for a bad user experience. In older versions of Excel, it was possible to turn this off.
It's strange that so few people feel concerned with that issue. Maybe there is a way to get rid of that yellow warning?