Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Haimanti
New Member

Extract data table from Count of X

Hello,

Please advise on the steps to follow to Extract data table from a Power BI file with "Count of X" 

Thanks

3 REPLIES 3
suparnababu8
Super User
Super User

Hi @Haimanti _ your questins is not clear. Pls share a pbix file with dummy data and what is input and what is expected output in screen shots. Thanks

Anonymous
Not applicable

Hi @Haimanti 

The 'Count of X' you mentioned, what exactly does it refer to? Is it a file name? If you want to export data from a Power BI file, you can refer to the following document.

Export data from a Power BI visualization - Power BI | Microsoft Learn

If you are connected to the data in import mode, you can directly copy the table in the table view.

 

 

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Haimanti , Not very clear.

 

You can create a visual and export.

Add, not summarized columns as group by and count of column in a table visual .

 

Or you can copy paste a table from data view to excel if needed 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.