Deleted Columns & Power BI

Chris Mondeau

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?

Sean Morgan

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

Sean Morgan

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

ossalcido

what if the columns were deleted in smartsheet can I just delete those columns in the table section of power bi?