Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone, I'm trying to extract a data from a matrix, but the option doesnt show. In the desktop I have the option, for all other tables in the dash published I'm to extract but for this matrix I dont have the option, there's only an option to copy as image.
Solved! Go to Solution.
HI @Anonymous ,
To work around the issue temporarily, you can use @MattAllington's suggestion to create a PowerPivot table in Excel. Or you can use PowerBI Tiles add-in in the Excel to get matrix visual. See: Integrating Power BI Tiles into Office documents.
Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.
Best Regards
Lucien
HI @Anonymous ,
To work around the issue temporarily, you can use @MattAllington's suggestion to create a PowerPivot table in Excel. Or you can use PowerBI Tiles add-in in the Excel to get matrix visual. See: Integrating Power BI Tiles into Office documents.
Besides, I found there is a same feature request posted in Power BI Idea forum, you can vote and comment on it: Allow Table and Matrix Data Exports to Match PowerBI Visual.
Best Regards
Lucien
Thank you for you answer I also notice later that we're able to extract the data if you have edit option on the power bi online.
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
1 |
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
3 |