Forum

Notifications
Clear all

Embed Excel Dashboard into SharePoint

4 Posts
2 Users
0 Reactions
833 Views
(@amberly-milleradp-com)
Posts: 2
New Member
Topic starter
 

I'm fairly new to Dashboards and I've found myonline training hub to be fantastic! Thank you!!

I have now created my interactive dashboard with slicers and I now need to embed the dashboard into my department's SharePoint site. I've watched Mynda's How to video several times. I have taken the following code from the written instructions of the video and replaced the URL with my URL. Unfortunately I'm still getting my ribbon/header, top & side scrollbars, etc. What am I missing here? Any input would be most appreciated. (I've included screenshots of the outcome). Please note: I had to remove the I_FRAME code to post my question.

Training Code:
I-FRAME width="500" height="200" frameborder="0" scrolling="no" src="https://yourDomain.sharepoint.com/:x:/g/personal/your_account_name/Ebb8wJNS4c9Ek7v2AE_BasEBSva-RhFqnL9pKJONWkFXYZ?e=auWtrP&action=embedview&wdbipreview=True&wdAllowInteractivity=True&wdHideSheetTabs=True&Item=dashboard&wdHideHeaders=True&ActiveCell=A35">

Here's what I have in my SharePoint Webpart:
I-FRAME width="500" height="200" frameborder="0" scrolling="no" src="https://adponline.sharepoint.com/:x:/s/NASImplWhiteLabelPartners/Ee95Mr9sjNJCi6Bt0ap8y18BbIMGnTD7Iq8fztei0nxW-A?e=TY2jUY&action=embedview&wdbipreview=True&wdAllowInteractivity=True&wdHideSheetTabs=True&Item=dashboard&wdHideHeaders=True&ActiveCell=A35">

 
Posted : 05/01/2023 2:51 pm
(@catalinb)
Posts: 1937
Member Admin
 

Check again the article please, there may be multiple scenarios, all described here:
https://www.myonlinetraininghub.com/embedding-excel-dashboards-in-a-web-page

 
Posted : 08/01/2023 4:31 am
(@amberly-milleradp-com)
Posts: 2
New Member
Topic starter
 

Catalin, Thank you for the reply, however, as mentioned, I've been through that article/video many times. How to prevent my dashboard from resizing itself once embedded into my Sharepoint site, is not covered. Might you have some other suggestions or thoughts on this? Thank you kindly.

 
Posted : 10/01/2023 9:16 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Amberly,
The IFrame is a standard html object, all the options are described here:
https://www.w3schools.com/tags/tag_iframe.ASP

You can also inspect the object using browser developer tools, to see if the object properties are overwritten by site css style defaults, but this involves html/css knowledge.

Once you set a fixed size, it should not be resizable indeed. Try setting the size with the style attribute of the iframe, using CSS properties to define a style:
iframe scrolling="no" style="height:200px;width:500px;border:2px solid red;" src="..."
The order of the attributes does not matter:
iframe
src="..."
style="..."
scrolling="..."
Should be the same as:
iframe
scrolling="..."
src="..."

 
Posted : 11/01/2023 1:51 am
Share: