The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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).
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.
I found some help on posting an image to a forum. Hopefully this works!
This is what ends up on my dashboard.
[IMG]http://i65.tinypic.com/2qw3hcj.png[/IMG]