Solved: database updates

bhmiller89 · ‎03-21-2018

I pull data from a databse at my company. Last night the head developer pushed an update and broke 17 of my auto refreshes.

When I went to investigate within the desktop files, one of the errors I found was:

vwJMWebJobSummary won't refresh because "The Column 'ProductHold' of the table wasn't found"

Is there a way to update the import of data without disrupting anything in the file? I wasn't using that column for anything, I had actually removed it

Anonymous · ‎03-21-2018

@bhmiller89,

In your PBIX file, please go to "APPLIED STEPS" in Query Editor, some steps should refer to the removed column 'ProductHold', delete these steps(“Renamed Columns” ,”Change type” and so on), the error should go away. Then you can re-add new steps to change type for your existing columns or rename your existing columns.

Regards,
Lydia

View solution in original post

Anonymous · ‎03-21-2018

@bhmiller89,

In your PBIX file, please go to "APPLIED STEPS" in Query Editor, some steps should refer to the removed column 'ProductHold', delete these steps(“Renamed Columns” ,”Change type” and so on), the error should go away. Then you can re-add new steps to change type for your existing columns or rename your existing columns.

Regards,
Lydia