Forum Discussion

mcsolrac9494's avatar
mcsolrac9494
New Member
3 years ago
Solved

Create a new hierarchy without republishing

Hi there, 

I have a power BI dataset with a hugh number of records in my fact table. It is published onto Power BI service and refreshed successfully. Now the client would like to add new hierachies to the model from existing dimension tables in the model. Is there a way that I can create these hierarchies without having to re-publish the desktop file to power bi service and reload to full data again?

 

Thanks

 

PS.  I am thinking to use the ALM tookit to do a schema change, however not sure if it will work for hierarchies.  

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    You can use ALM Toolkit to push meta data changes up into the service without requiring a dataset refresh.  Then you can use Enhanced Refresh or XMLA scripts to refresh individual partitions.

1 Reply

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

    You can use ALM Toolkit to push meta data changes up into the service without requiring a dataset refresh.  Then you can use Enhanced Refresh or XMLA scripts to refresh individual partitions.