Connect Power BI to Smartsheet EU Region

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

Hi, I'm trying to connect from Power BI to data in the Smartsheet EU region. Every solution I find seems to use the default instance, with no way to configure for use with the Europe instance.

I've already reviewed the following options:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-to-smartsheet
http://smartsheet-platform.github.io/odbc-docs/#overview%C2%A0%C2%A0

I'm trying to avoid building out some API solution from scratch. Has anyone used a solution that allows connection to the Europe instance?

· Share on Facebook Share on Twitter

Answers

Categories

Hi @Emmy Anderson<\/a> <\/p>

You are not missing anything. This is how DV works with dropdowns unfortunately. My work around in the past is to create an other option in the drop down, user chooses save. Then have logic built for a text field that appears so the user can input the values not present in dropdown. <\/p>

Hope this helps<\/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":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":107733,"type":"question","name":"Active Directory Integration","excerpt":"Hello, We have recently setup our Active Directory Integration. Are we able to pull data that is included in AD into a sheet in Smartsheet? For example: Name, Title, Department? And if so, how? Thanks, Melitta","snippet":"Hello, We have recently setup our Active Directory Integration. Are we able to pull data that is included in AD into a sheet in Smartsheet? For example: Name, Title, Department?…","categoryID":343,"dateInserted":"2023-07-18T14:35:41+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T19:00:49+00:00","insertUserID":131821,"insertUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-07-19T18:59:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":131821,"lastUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-07-19T18:59:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3379485390,"url":"https:\/\/community.smartsheet.com\/discussion\/107733\/active-directory-integration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107733\/active-directory-integration","format":"Rich","lastPost":{"discussionID":107733,"commentID":386058,"name":"Re: Active Directory Integration","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386058#Comment_386058","dateInserted":"2023-07-19T19:00:49+00:00","insertUserID":131821,"insertUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-07-19T18:59:57+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":"2023-07-19T19:00:44+00:00","dateAnswered":"2023-07-19T15:54:45+00:00","acceptedAnswers":[{"commentID":385977,"body":"

@Melitta<\/a> the only way to do this is via the API. If you have Bridge then you could achieve this.<\/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":[]},{"discussionID":107797,"type":"question","name":"Why is my global update to add profile data coming in blank in tests?","excerpt":"Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…","snippet":"Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column…","categoryID":343,"dateInserted":"2023-07-19T14:36:17+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T17:21:41+00:00","insertUserID":163671,"insertUser":{"userID":163671,"name":"warrena","title":"SVP Operations","url":"https:\/\/community.smartsheet.com\/profile\/warrena","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BwvmQS-uIbI!gk_kZ2_XMHI!WXFAoXDNJfe","dateLastActive":"2023-07-20T17:42:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-07-20T17:53:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":39,"score":null,"hot":3379568878,"url":"https:\/\/community.smartsheet.com\/discussion\/107797\/why-is-my-global-update-to-add-profile-data-coming-in-blank-in-tests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107797\/why-is-my-global-update-to-add-profile-data-coming-in-blank-in-tests","format":"Rich","lastPost":{"discussionID":107797,"commentID":386005,"name":"Re: Why is my global update to add profile data coming in blank in tests?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386005#Comment_386005","dateInserted":"2023-07-19T17:21:41+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-07-20T17:53:44+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\/50Z2MUOUC5U8\/screenshot-2023-07-19-at-10-31-00-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-07-19 at 10.31.00 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T17:17:08+00:00","dateAnswered":"2023-07-19T15:28:11+00:00","acceptedAnswers":[{"commentID":385957,"body":"

@warrena<\/a> Sometimes the test function can be a little wonky. It's hard to say for sure why its not showing up because your setup looks right. If it was me, I would apply to global update to only one project and then investigate. Just make sure when you go to the next step you only check one project to update.<\/p>"},{"commentID":385993,"body":"

@warrena<\/a> <\/p>

the screen after you do the test is this<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

When you hit apply update it will take you to the next and final screen and there will be the option to select the projects you want to apply the update to. Select only one and hit apply. <\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

This is after you do the test<\/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":[]}],"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":625,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Dynamic View - Dropdown Lists

    I have certain single and multiple select list columns that do not have the "restrict to dropdown values only" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…

  • Active Directory Integration

    Hello, We have recently setup our Active Directory Integration. Are we able to pull data that is included in AD into a sheet in Smartsheet? For example: Name, Title, Department? And if so, how? Thanks, Melitta

  • Why is my global update to add profile data coming in blank in tests?

    Hi all, I'm trying to make a global update to add a new profile data point (created date) to metadata and summaries. I've tried doing it with both the system created date column and a helper column replicating the created date column (read in another discussion that I should try that). Both result in an incomplete data row…

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

 Watch video