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