Forum Discussion
Adding new DB column to Power BI's dataModel [Import mode]
HeY my mates!
I was searching for some issues on adding existig database columns into Power BI "DBContext".
I've found two solustions:
1) https://www.youtube.com/watch?v=ZSUCmi6h5SY#t=5m45s - okey, I exactly want to do this, but I'm not using Power Query Mode but the Import Mode. I cant even navigate to menus & buttons used in provided link (above), problably they're not visible on report import mode.
2) add new calculated columns: https://community.powerbi.com/t5/Desktop/Add-column-to-a-table/m-p/1290845 - okey, for a training I have done this (with DAX), but my aim is not to add calculated column, but a new one, that was added to a DB view. How to refresh Power BI's data model to fetch my new column on entitiy ?
Yup, thats all ...
Looking 4 your repls 😉
powerBI admin --> If I have made a duplicate, please repost my message on appropriate topic.
!! EDIT !!
[solved] an ordinary "Refresh" btn has refresh my table. Topic for closing
How to refresh tbl metadata in dataModel
Observation: This may take a while, because Refresh data will update metadata about the model, and will import all data again.
2 Replies
- AllisonKennedyCommunity Championspazi have you found solution for both of your queries? If so, please Reply to your own post with a quick summary of what fixed it and mark your post as a solution. Cheers!
- spaziFrequent Visitor
How to refresh tbl metadata in dataModel
Observation: This may take a while, because Refresh data will update metadata about the model, and will import all data again.