Forum Discussion

spazi's avatar
spazi
Frequent Visitor
5 years ago
Solved

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

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    spazi 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!
  • spazi's avatar
    spazi
    Frequent 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.