Power BI Integration and Adding/Deleting columns

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???

Find more posts tagged with

Power BI

Accepted answers

che.rabajante

Hello @AnnThompson

Please follow these steps:

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

Hope this help.

Che

All comments

che.rabajante

Hello @AnnThompson

Please follow these steps:

Remove Columns in Power Query: Open Power BI > Transform Data > Remove unwanted columns from the Smartsheet query.
Check Applied Steps: Ensure no steps in Power Query reference the deleted columns.
Update the Data Connection: Refresh the Smartsheet connection to sync with the changes.
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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.