Forum Discussion

wojciech's avatar
wojciech
Helper II
3 years ago
Solved

CI/CD with incremental refresh partitions

Hi Community,

 

There are many ways to automate your PBI dataset deployment using tools such as PBI-tools, Tabular editor, DevOps Extensions, In-Line PowerShell - this is what I'm aware of at least. However, all these methods will overwrite incremental refresh partitions, and full dataset refresh will be required during or after deloyment. The only tool that can do a proper schema compare and update dataset with changes without a meed to run refresh is ALM toolkit. Howerer, there is no CLI for ALM toolkit so it can not be baked into DevOps pipeline (Am I correct)?

 

Is there any way to automate schema updates deployment for PowerBI datset?

 

Many Thanks,

 

Wojciech 

Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi wojciech 

     

    Yes you can make a change to the entire JSON structure and then update it, that should not enforce a refresh. I would strongly suggest testing this before rolling it out to a production environment.

4 Replies

    • wojciech's avatar
      wojciech
      Helper II
      3 years ago

      Hi GilbertQ ,

       

      I appreciate your reply.

      I can see that you can run a command to update schema only, but you need to pass JSON defining what changes you want to push. I think the chellange for me is how to create that JSON structure which would define what changes there are between my source and and target database. 

      I will dig into it.

       

      Thanks for your help.

       

      Wojciech

      • GilbertQ's avatar
        GilbertQ
        Super User
        3 years ago

        Hi wojciech 

         

        Yes you can make a change to the entire JSON structure and then update it, that should not enforce a refresh. I would strongly suggest testing this before rolling it out to a production environment.