cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vnkesa123
Microsoft
Microsoft

Export Power BI table visual in to excel

Hi,

 

I have a table visual with 987 rows. Now I want to export this data in to excel as it is. From Power BI service I have tried to export the data in different ways (summarize, underlying and current layout) but I am not getting all the data.

 

Can any one help me how to export all the data from Power BI table visual?

 

vnkesa123_0-1634110173975.png

Attached is the screenshot for the same

 

Regards,

Naresh Kumar

4 REPLIES 4
v-chenwuz-msft
Community Support
Community Support

Hi @vnkesa123 

 

The limitations in the article mention that if you are in Direct query mode there may be cases where you cannot export completely. You can try reducing columns and exporting multiple times to achieve exporting all columns. It may help you. https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

Or check if there are some filters has applied to the visual.

 

Best Regards

Community Support Team _ chenwu zhu

 

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

HarishKM
Super User
Super User

@vnkesa123  You can use this method to export your table in excel,

HarishKM_0-1634112024752.png

Click on the 3 dots on right and then hit export button and it will export an csv file for you and output will be like this in excel.

 

HarishKM_1-1634112078313.png

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.

Thank you 
Harish

Hi Harish,

 

Thank you for your help.

But this solution, I have tried. But the data was not downloaded completely. Instead of 987 rows 304 rows got exported to excel.

 

Regards,

Naresh Kumar

Marik
Solution Supplier
Solution Supplier

@vnkesa123 I'm not sure that it's what you need but when I have had similar requests I did it through DAXStudio:

write DAX in DAXStudio that returns needed table and choose as an output 'linked Excel'.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.