Yugantika Manekar on 01 Feb 2022 16:11:05
Excel shows a full cross join of dimensions unless you also include a measure into the pivot table. So, we will need to add a measure into the pivot table to get the "show nonempty" behavior in respective Analyze in excel file.
This is not documented and will need to update the documentation on this topic.
Mithun Aj on 01 Feb 2022 16:23:34
RE: Update documentation for Analyze in Excel for carrying the model relationship to excel file.
Document which has to be updated - Start in Power BI with Analyze in Excel - Power BI | Microsoft Docs