topic Re: Blank Excel document on Export from PBI viz in Report Server

Blank Excel document on Export from PBI viz

FOXYBARK — Thu, 25 Jul 2024 20:05:55 GMT

HI there.

I have read the posted articles regarding this topic but none of the troubleshooting tips have worked. I'm exporting from a report, one of the visuals and the Excel/CSV is blank. I have tried several things to remedy.

- Different browsers

- settings in PBI desktop and PBI server to allow exporting of summarized data

This blankness is happening on all 4 tabs of the report and all the visuals within.

Any ideas would be appreciated.

Thanks

Re: Blank Excel document on Export from PBI viz

Anonymous — Fri, 26 Jul 2024 02:01:11 GMT

Hi, FOXYBARK

If you export data for a live connection model, then you need to enter the relevant credentials. You can refer to the following case with the same issue:

Solved: Export data from visual is returning blank excel - Microsoft Fabric Community

At the same time you can see if you fall within the current limitations of the exported Excel:

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

Best Regards

Jianpeng Li

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

Re: Blank Excel document on Export from PBI viz

FOXYBARK — Fri, 26 Jul 2024 15:08:39 GMT

Thank you. THis does not help me as I've already read this very same article. Thanks anyway.

Re: Blank Excel document on Export from PBI viz

Anonymous — Mon, 29 Jul 2024 07:11:28 GMT

Hi, FOXYBARK

Can you describe to me your steps to reproduce the current issue? In my tests, I was able to export data from visuals from Report Server and Power BI Service as expected.
Is your current issue limited to the current report or is all of your reports affected? This can help you determine if there may be a problem with the design of your current report, if your other reports don't have this problem.

Best Regards

Jianpeng Li

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

Re: Blank Excel document on Export from PBI viz

FOXYBARK — Mon, 29 Jul 2024 15:06:50 GMT

Hi there.

I was able to resolve on my own. The issue appeared to be within Excel and not PBI. It seems as though there was a pivot table somewhere that I couldn't see. When I click on Report Layout -> Show in Tabular Form on Excel's design tab, something happened and all of a sudden I could see the pivot table fields . I closed Excel and tried the export again from the top. Now I can see the exported data without having to do any pivot table steps.