pin image is not same size as what is in excel

Anonymous · ‎07-12-2017

Hello,

I am attempting to pin a small pivot table from Excel to my dashboard; however, when I click to "Pin" the table the data is resized to a larger font and only parts of my table can be seen and therefore it is only pinning a part of my data. I have tried changing the font size to super tiny - that did not work. I also tried just typing in the data and selecting it instead of the pivot table - again I get the same resizing.

I am not sure why this is happening, as far as I know I haven't selected anything to make this happen, so I have no idea how to fix it.

Territories	Requests
Midwest	35
Northeast	44
Northwest	24
South	62
Southwest	35
Grand Total	200

*Here is the data I am trying to pin*

https://app.powerbi.com/groups/me/dashboards/94112d71-85f6-4e8d-9485-ad3f6187c8b9

*Here is what gets pinned on my dashboard*

Help please!

Thank you!

Tera

Anonymous · ‎07-12-2017

Quick note: we're not going to be able to see what's in that link. That's private to your O365 tenancy, and I'm pretty sure that's in your own personal workspace, judging by the "groups/me/" path. You'll need to include screenshots instead.

Long story short, Power BI dashboards do a bit of their own thing when it comes to formatting. In nearly all cases, even when pinning a Power BI report element, the pinned item takes on a dashboard-specific formatting, mostly only retaining the data itself. I could be wrong, but I do not think there is a recourse for this other than potentially using specific table formattings in Power BI (I'm not entirely sure if these look different once pinned).

Anonymous · ‎07-12-2017

Thank you for the quick reply SonnyChilds, but I cannot figure out how to post a screen shot... 😞

The resizing happens before I even post it to my dashboard - the resizing happens when I am still in Excel and I click "Pin."

I also tried restarting excel, opening different workbooks, and even different versions of Excel (2016 & 2007) and it did the same thing in each case.