Showing results for 
Search instead for 
Did you mean: 

Export Power BI table visual in to excel



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?



Attached is the screenshot for the same



Naresh Kumar

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.

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.

Super User
Super User

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


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.



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

Thank you 

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.



Naresh Kumar

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

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.