Forum Discussion

tsimpkins's avatar
tsimpkins
Frequent Visitor
1 year ago
Solved

Power Query Matrix As Power Automate HTML Table

Hi,   I have created a Power Automate Flow that uses a Power Query to Get the data set from a Matrix visual in a Power Bi report. It then takes the data set and creates an HTML Table. The issue I h...
  • v-pnaroju-msft's avatar
    1 year ago

    Hi tsimpkins,

    We sincerely appreciate your inquiry on the Microsoft Fabric Community Forum.

    To expand all levels in the Matrix visual within Power BI Desktop, right-click on any row header and select Expand all. Once you have done this, saving and publishing the report should retain the expanded state.

    If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

    Thank you.