Hi Everyone, I recently encountered a challenge with sharing data from a Power BI matrix visual that contains more than 100 rows. I’m looking for a way to automatically share this data in table format—without manually exporting it to CSV or Excel each time. Please note that I do not want the output in image or PDF format. The requirement is to share the actual tabular data in a usable and structured format, similar to what is shown in the Power BI visual. For reference, I’ve attached an image of the matrix visual.

Hi Manav-Shah, Thank you for the follow-up. Given that your primary requirement is to automatically share matrix visual data in a structured format (excluding image or PDF) and you do not have a Premium license, here are your current options: You can automate the export process using Power Automate along with Power BI REST API or Dataflows. This will enable you to extract and send tabular data (such as that in your matrix visual) on a scheduled basis, eliminating the need for manual exporting. First, identify the table or measure that feeds your matrix visual in Power BI Desktop. Utilize Power BI Dataflows (or create a custom table if necessary) to store the summarized data behind your matrix. Next, in Power Automate, set up a scheduled flow: Use the Power BI REST API or connect to the Dataflow. Retrieve the table data, export it to Excel or CSV format, and send it via email or upload to OneDrive/SharePoint. If you are open to using Excel: Open Excel → Data → Get Data → From Power BI. Select your dataset and import the table used in the matrix. Format and share the Excel file, which can be refreshed on demand or upon opening, making sharing dynamic.Please refer to the below documentation link:Matrix visual format settings - Power BI | Microsoft LearnMatrix visual considerations and limitations - Power BI | Microsoft LearnAlso can you please look into this solved solution which is related to the thread:Solved: I want Export data of matrix visual in matrix for... - Microsoft Fabric CommunityIf this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Thank you again for reaching out to the Microsoft Community Forum.

Need Help Automating Power BI Matrix Visual Data Sharing

Forum Discussion

Related content

Automate table extract from report & upload file to share point

Automated refreshes

Automating API link updates

Report Sharing

PowerBi and Power Automate