Skip to main content

    Power BI

    Needs Votes

    Update documentation for Analyze in Excel for carrying the model relationship to excel file.

    Vote (12) Share
    Yugantika Manekar's profile image

    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.

    Comments (1)
    Yugantika Manekar's profile image Profile Picture

    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