Forum Discussion
Export to excel only works on some tables
Hi all,
I have a report on the report server (Jan 2020 release) containing a table of 16 columns (6 measures and 10 attributes which are not coming from a hierarchy). With all filters applied I have about 12 records in the table, so far less than 30k or 150k. The report gets its data from an OLAP. On the PC I have excel 2016.
what happens:
- export to excel -> does not work / the browser does not prompt any download (tried with multiple browsers)
- export to csv of the same data -> works
- export of other tables / visuals to excel -> works
I'm really baffled as to why it doesn't work. Did some of you ever had a similar problem?
Thanks, Pietro
Thank you for the reply.
I did some further testing on the issue and I have found that it was related to the filters on the visual.
For some reason I had a visual level filter based on a measure which wasn't working.
While seeing the report from the browser there wasn't any problem but when exporting it, it didn't work.
Have a nice day, Pietro
2 Replies
bradsyMicrosoft Employee
There are a few limitations, not sure you have read this: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations
Empty column names or duplicate column names also seem to cause it not to work.
Also, there maybe some traces in the log files, look for the RSPowerBI.... file.
\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles
Thank you for the reply.
I did some further testing on the issue and I have found that it was related to the filters on the visual.
For some reason I had a visual level filter based on a measure which wasn't working.
While seeing the report from the browser there wasn't any problem but when exporting it, it didn't work.
Have a nice day, Pietro