Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Schema refresh in the service

I have a semantic model that pulls data from a PostgreSQL database. Sometimes, I change table schema, i. e. add (or remove) a column. So, I need a schema refresh for these tables in my semantic model...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    - refresh the Power BI Desktop with the new column. Don't publish.

    - use ALM toolkit to connect to both the local and service semantic models

    - push the meta data change without refresh

    - use the XMLA endpoint to selectively refresh the affected partitions.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

ALM Toolkit is the tool that's mostly used in such scenarios.  You can also run your XMLA scripts manually.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Could you elaborate on how that would be done? Let's say I have a table in my database and load it into PBI (import mode) without doing any transformation. Then I add a column to the database table. Now this column won't be loaded if I do a refresh in the service (only with PBI desktop). What exactly can I do now without using PBI desktop?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    - refresh the Power BI Desktop with the new column. Don't publish.

    - use ALM toolkit to connect to both the local and service semantic models

    - push the meta data change without refresh

    - use the XMLA endpoint to selectively refresh the affected partitions.