Forum Discussion
Helper IIIBlank Excel document on Export from PBI viz
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.
Helper IIIThank you. THis does not help me as I've already read this very same article. Thanks anyway.
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.
- FOXYBARK
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.