Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
Deleted Columns & Power BI
Hi All! I seem to keep running into this when myself or another team member deletes a column in smartsheet, and ends up breaking a sync in Power BI.
Often we'll remove columns from a sheet that aren't actively used on PBI reports, but are either part of the source sheet or report. This breaks the sync, and it's kind of a hassle to reconfigure.
Does anyone have recommendations on the PBI side of things to make this easier?
Best Answer
-
Hello @Chris Mondeau ,
Although I don't have a testing environment for PBI, you may wish to instead hide the Columns within Smartsheet to maintain the sync, but hide the unrequired data from the Sheet.
Let me know if you have any questions
Regards
Sean
Answers
-
Hello @Chris Mondeau ,
Although I don't have a testing environment for PBI, you may wish to instead hide the Columns within Smartsheet to maintain the sync, but hide the unrequired data from the Sheet.
Let me know if you have any questions
Regards
Sean
-
what if the columns were deleted in smartsheet can I just delete those columns in the table section of power bi?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- Hi, I am looking for the latest and greatest training information regarding how to sync your SmartSheet calendar with your outlook calendar. If anyone can help, please let me know. Thank you, Allison …
- Hi Everyone, My team is experiencing an issue where in the Smartsheet Outlook add-in our favorites option is blank. We confirmed that in Smartsheet our favorites lists are still intact but we are not …
- Am I the only one missing two of the three AI tools today? I should be seeing: Analyze data Generate formulas Text and summaries But only "Analyze Data" is available.
