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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Export Data Option from Table Visual Returns Blank Rows in XLSX

Hi,

 

As the title explains, when I click 'Export Data' on my table visual and select XLSX format, the file generated is returning only blank rows.  I've never seen this before - can someone please assist?

 

Thanks in advance.

Status: New
Comments
v-robertq-msft
Community Support

Hi, @garynorcrossmmc 

Unfortunately, I can’t reproduce the same issue as yours. I think you should make sure you have the “Build” permission to the underlying dataset and your visual data is not completely filtered.

This is my test screenshot:

v-robertq-msft_0-1623294823783.png

v-robertq-msft_1-1623294823785.png

 

You can also refer to this link to check if you have met the limitations of the function:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

 

Best Regards,

Community Support Team _Robert Qin