Power BI Integration and Adding/Deleting columns

AnnThompson

I have our exit interview metrics built in Power BI from a form/sheet in Smartsheet! LOVE it, working great until I added 2 columns that I do not want in Power BI, not sure how to do this. I have tried removing the columns in Power BI, then I just get errors on the refresh that the columns are not that, I have no clue what to do any more and am so frustrated as I am sure it is simple. Is there a Power BI expert with SS that can help???

che.rabajante

Hello @AnnThompson

Please follow these steps:

1. Remove Columns in Power Query: Open Power BI > Transform Data > Remove unwanted columns from the Smartsheet query.
2. Check Applied Steps: Ensure no steps in Power Query reference the deleted columns.
3. Update the Data Connection: Refresh the Smartsheet connection to sync with the changes.
4. Check for Dependencies: Update or remove any measures, calculated columns, or relationships relying on the removed columns.

Hope this help.

Che

che.rabajante

Hello @AnnThompson

Please follow these steps:

1. Remove Columns in Power Query: Open Power BI > Transform Data > Remove unwanted columns from the Smartsheet query.
2. Check Applied Steps: Ensure no steps in Power Query reference the deleted columns.
3. Update the Data Connection: Refresh the Smartsheet connection to sync with the changes.
4. Check for Dependencies: Update or remove any measures, calculated columns, or relationships relying on the removed columns.

Hope this help.

Che

AnnThompson

Thank you Che! Your step 2 is what fixed it, I didn't realize I had to delete them from the actual code/step!

Deleted the reference, boom, WORKED!! Thank you!

Ann