Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

PBI desktop truncated table rows PDF export

Submitted by Anonymous on ‎02-09-2021 06:33 AM

Hi all,

 

We are currently running into problems while trying to export our PBI reports as a PDF. Some rows in tables aren't high enough, and as a result the data (text) is truncated (see image below).

 

CamillePfeiffer_0-1612880576090.png

 

Our data is composed of a series of excel spreadsheets located in a sharepoint site, which contains multiple rows of text (updates on a number of issues etc.). We import that data via the SharePoint.Contents function in the power query editor. That data is then presented in the report via table visualizations. Sometimes the data is a relatively large chunck of text, and at occasions the text includes line return, simulating bullet points. It seems that truncated rows are related to data entries with line returns.

 

I have noticed that this problem does not occur on my PBI version (2.87.762.0 64). I suspect it has to do with latest updates.

 

Has anybody ran into the same issues, and found a fix for it? We seem to have found a way around by exporting PowerPoints via the web portal, and then exporting PDFs from powerpoint. This procedure is however a bit lengthy and I would prefer being able to rely on the PDF export from the desktop application.

 

Best!

Camille

Status: New
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎02-09-2021 06:58 AM

The version that my colleagues are running which causes problems is : 2.88.1682.0 64-bit (December 2020)

v-yingjl
Community Support
Community Support
‎02-09-2021 10:13 PM

Hi @Anonymous ,

Has used the same version of power bi desktop to test but could not reproduce it in my side.

version.png

table visual in desktoptable visual in desktopexport to pdfexport to pdf

Perhaps you can change the row padding of the table visual in 'Grid' tab and check it again.

padding.png

 

Best Regards,
Community Support Team _ Yingjie Li

Anonymous
Not applicable
‎02-10-2021 02:26 AM

Hi @v-yingjl 

 

Thanks for the quick response. We had a crack at playing with the row padding but with no success unfortunately:

CamillePfeiffer_0-1612951925786.png

 

We tried to change the paper ratio back to a standard ratio type (currently set to A standard ratio for printing), but again we had the same issue.

 

I did however start from fresh and indeed the error isn't showing (as per your trial). I'll try to push this further later today and see if I can pin point what causes the error. 

 

Thanks,

Camille

 

ehealy
New Member
‎03-01-2022 10:31 AM

Did you ever find a resolution to this?

 

We have users that have reports doing this. But only AFTER updating to version 2.100.1381.0

 

They are having no issues on version 2.99.621.0

Idea Statuses