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???
Best Answer
-
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
Answers
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives