Forum Discussion

NS90's avatar
NS90
Microsoft Employee
2 years ago

Handle schema changes in the table without republish

I have a report which is running in PBI service. One of the tables in RDBMS has a chaging schema, where users can add columns to this table.

Now everytime there is a schema change I have to open the report in PBI desktop refresh to get the added columns and republish the report.

 

Is there a way where it can be handled in service without need to republish?

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Not in the service directly but with XMLA Write access.  You can use tools like ALM Toolkit or Tabular Editor.

     

    If you don't need these additional clumns consider to hide the table behind a view. If you need them consider unpivoting your data.