Smartsheet Dashboard Embed Power BI

dweir
dweir ✭
edited 06/14/22 inAdd Ons and Integrations

The new dashboard feature for Smartsheet says we can embed power BI reports by publishing to web, but doing that in Power BI makes your report public to everyone. How can I embed while still mainting privacy as these reports have company information?

There is a Power BI option that allows you to embed directly to Sharepoint, but that link doesn't seem to work for smartsheet.

Tags:
· Share on Facebook Share on Twitter

Comments

  • Kelsey Hayden
    Kelsey Hayden ✭✭✭✭

    Hello,

    Thanks for reaching out! At this time, in order to embed a Power BI report, you would need to click File > Publish to Web, and copy the embed code or link provided and paste it into the Web Content widget field.

    When using the Web Content widget, certain applications require that you publish content to the web in order to obtain the required embed code. This means that you may expose otherwise private documentation to anyone who obtains the link themselves. For more information on this, please see this Help Center article:https://help.smartsheet.com/articles/2477606-web-content-widget).

    With regards to Sharepoint, currently we don't have the ability to embed a Sharepoint page URL but I have submitted a feature request on your behalf to our Product team so that they can consider it for future capability. If you would like to request a domain to be approved, we also invite you to please fill outthis form.

    To ensure that the information within the Dashboard is private you could consider the following:

    • If you are publishing the Dashboard, you can use the Access Control options to control whether the link will be accessible by anyone or only by users in the dashboard owner's account. You could also copy and share the link that's available in the Dashboard Properties window. The link available from the properties window is secure and only accessible to shared collaborators. More information on publishing Smartsheet items can be found here:https://help.smartsheet.com/articles/522078-publishing-smartsheet-items
    • You can control which users are shared to the Dashboard, and have access to the data embedded in the Web content widget. All shared collaborators can use the secure sheet link to open the dashboard directly, however, when using the link, users will still be prompted to log in to Smartsheet (if they aren't already logged in) in order to access the data.

    Please let me know if you have any questions about this and I’ll be more than happy to advise further!

    · Share on Facebook Share on Twitter
  • angczo
    angczo ✭✭

    嗨,凯尔ey,

    Is there any further development on that?

    It would be good to have an option to share internal dashboard securely in SharePoint without users additionally login in to Smartsheet.

    Kind regards,

    Angelika

    · Share on Facebook Share on Twitter

Categories

Hi @Matthew LeMasonry<\/a> <\/p>

No, it currently isn't possible to share the Data Shuttle workflow configuration with another account. The set-up for that workflow is associated with one account. (Please let our Product team know of your feature request by filling in this form, here!)<\/a><\/p>

That said, many team members will be able to trigger<\/em> that workflow, depending on what that trigger is. For example, if the workflow is based on an attachment, any user can upload the attachment for the workflow. Does that make sense?<\/p>

If you are looking to transfer workflows because a user has left the organization, you could potentially update the Primary email address associated with the account that owns the configurations. This will allow you to gain access to the Data Shuttle workflows from the new email. Keep in mind this would need to be an email that does not currently have a Smartsheet account. See: Admin Center: Add, Edit, and Delete Individual Users with User Management<\/a><\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107864,"type":"question","name":"Anyone else having issues with Calendar App not Downloading PDF of entire calendar?","excerpt":"I have been on the phone with Smartsheet support this week but we have been unable to figure out what could be causing this issue. I am finding that the Calendar app is only Downloading one page of a PDF, cutting off any information that would be on the subsequent pages. Example below You can see the bottom four lines,…","snippet":"I have been on the phone with Smartsheet support this week but we have been unable to figure out what could be causing this issue. I am finding that the Calendar app is only…","categoryID":343,"dateInserted":"2023-07-20T16:17:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-25T16:28:06+00:00","insertUserID":156581,"insertUser":{"userID":156581,"name":"Macorne","url":"https:\/\/community.smartsheet.com\/profile\/Macorne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T17:22:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":156581,"lastUser":{"userID":156581,"name":"Macorne","url":"https:\/\/community.smartsheet.com\/profile\/Macorne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T17:22:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":43,"score":null,"hot":3380173551,"url":"https:\/\/community.smartsheet.com\/discussion\/107864\/anyone-else-having-issues-with-calendar-app-not-downloading-pdf-of-entire-calendar","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107864\/anyone-else-having-issues-with-calendar-app-not-downloading-pdf-of-entire-calendar","format":"Rich","tagIDs":[449],"lastPost":{"discussionID":107864,"commentID":386931,"name":"Re: Anyone else having issues with Calendar App not Downloading PDF of entire calendar?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386931#Comment_386931","dateInserted":"2023-07-25T16:28:06+00:00","insertUserID":156581,"insertUser":{"userID":156581,"name":"Macorne","url":"https:\/\/community.smartsheet.com\/profile\/Macorne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-27T17:22:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JTO6PBQV26S0\/pdf-cutoff-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PDF cutoff.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-25T16:27:54+00:00","dateAnswered":"2023-07-25T12:38:16+00:00","acceptedAnswers":[{"commentID":386813,"body":"

Hey @Macorne<\/a> <\/p>

I checked in with our Support team and they confirmed that two other users had reported a similar behaviour as well. Thank you for your patience and persistence as we looked into this!<\/p>

We've since had confirmation that there has been a fix in the Print behaviour for the Calendar app as of this weekend. Please try again and let us know if this has now been resolved for you. <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":449,"urlcode":"calendar-app","name":"Calendar App"}]},{"discussionID":72863,"type":"question","name":"Document Builder - date format?","excerpt":"I am trying to generate certificates of completion with document builder and include the date of conferral. No matter how I enter the date into a date field (my preference is \"Friday, January 1, 2021\" as the format), it always enters in the 1\/1\/21 format. Any ideas for getting document builder to fill it correctly?","snippet":"I am trying to generate certificates of completion with document builder and include the date of conferral. No matter how I enter the date into a date field (my preference is…","categoryID":343,"dateInserted":"2020-11-04T23:06:36+00:00","dateUpdated":"2022-06-14T14:37:26+00:00","dateLastComment":"2023-07-21T23:09:55+00:00","insertUserID":128195,"insertUser":{"userID":128195,"name":"Robin Sugiura","url":"https:\/\/community.smartsheet.com\/profile\/Robin%20Sugiura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T19:16:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":150391,"lastUser":{"userID":150391,"name":"Rebecca Ortinez","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca%20Ortinez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T18:48:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":784,"score":1,"hot":3294520891,"url":"https:\/\/community.smartsheet.com\/discussion\/72863\/document-builder-date-format","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72863\/document-builder-date-format","format":"Rich","lastPost":{"discussionID":72863,"commentID":386528,"name":"Re: Document Builder - date format?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386528#Comment_386528","dateInserted":"2023-07-21T23:09:55+00:00","insertUserID":150391,"insertUser":{"userID":150391,"name":"Rebecca Ortinez","url":"https:\/\/community.smartsheet.com\/profile\/Rebecca%20Ortinez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T18:48:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-05T09:58:05+00:00","dateAnswered":"2020-11-04T23:19:01+00:00","acceptedAnswers":[{"commentID":267977,"body":"

I figured out a workaround -- if the date is entered in long form in a text column instead of a date column, it populates as entered. <\/p>

Don't know if there is another way to affect the formatting if populating from a date column.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":626,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Share Data Shuttle Workflows?

    When someone creates a workflow in Data Shuttle to import data from a CSV file, how can we share this with other team members to support and adapt if required? Also if they are on leave, to enable other to run the workflow.

  • Anyone else having issues with Calendar App not Downloading PDF of entire calendar?

    I have been on the phone with Smartsheet support this week but we have been unable to figure out what could be causing this issue. I am finding that the Calendar app is only Downloading one page of a PDF, cutting off any information that would be on the subsequent pages. Example below You can see the bottom four lines,…

  • Document Builder - date format?

    I am trying to generate certificates of completion with document builder and include the date of conferral. No matter how I enter the date into a date field (my preference is "Friday, January 1, 2021" as the format), it always enters in the 1/1/21 format. Any ideas for getting document builder to fill it correctly?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video