Forum Discussion
To add a new field from a data source
Hi, there is a change of my data source with an extra column for new field. i tried to refresh my power BI but the new column doesn't show up. In fact, i received an error message when i tried to refr...
Hi, The error message is " The column column 76 of the table wasn't found. i tried to attach a pic to illustrate my point but unsuccessful. can you send me your email so that i can send a link to you via onedrive.
It definitely sounds like an issue with the transformation steps in the query, or possibly the cache. I suspect this thread is very similar to your situation and similar steps may resolve your problem:
https://community.powerbi.com/t5/Desktop/Removing-any-columns-causes-errors/m-p/414805#M190415
If you're still having trouble after reviewing it might be better if you can provide a link to your report and I can have a look for you.
Good luck!
Daniel
https://community.powerbi.com/t5/Desktop/Removing-any-columns-causes-errors/m-p/414805#M190415
If you're still having trouble after reviewing it might be better if you can provide a link to your report and I can have a look for you.
Good luck!
Daniel
- Hi Dm-p, My problem is the error appeared after i had added two more columns into my database and did a refresh of my PBI. The error message is " PI Register The column 'Column76' of the table wasn't found." Thanks a lot for your help and patient.