Forum Discussion

mshparber's avatar
mshparber
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Deploy changes without Data Refresh

I have a large model that takes 30 minutes to refresh on a strong Desktop. It is scheduled to refresh in the Service (PPU Workspace). I frequently make changes to visuals and measures but I befo...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    You want to make sure you have separated off your power bi report layer (https://m.youtube.com/watch?v=PlrtBm9YN_Q) and then as lbendlin suggests use the xlma end point. Everything you can do with on prem SSAS is there. I connect to my model using tabular editor but you can use visual studio. Only use power bi desktop for report visual design. Everything else sits in tabular editor/visual studio.

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

You want to make sure you have separated off your power bi report layer (https://m.youtube.com/watch?v=PlrtBm9YN_Q) and then as lbendlin suggests use the xlma end point. Everything you can do with on prem SSAS is there. I connect to my model using tabular editor but you can use visual studio. Only use power bi desktop for report visual design. Everything else sits in tabular editor/visual studio.

  • mshparber's avatar
    mshparber
    Icon for Advocate I rankAdvocate I
    4 years ago

    Ok, this can work. So I'll have to change measures in the Visual Stusio / Tabular Editor and deploy only metadata. And the Visuals I need to change in the reporting .pbix file....
    Then it means I have to make changes in two places, but still a possible solution, thanks.

    What about Pipelines? Can that work?

    • bcdobbs's avatar
      bcdobbs
      Icon for Community Champion rankCommunity Champion
      4 years ago

      I suppose I've always seen it as separate concerns rather than making changes in two places. I work on a central data model in tabular editor/VS just as I would do with an on prem SSAS instance (Microsoft describe power bi premium/premium per user as being a superset of azure analysis services). 

      Then I consume that data model in power bi reports, excel etc.

       

      I think deployment pipelines would work though. Only thing you have to watch is if you make a certain changes to the model (relationships/calculated columns) you then need to connect to the xlma end point and force a recalculation at least if you don't do a full refresh.

      • HitachiOG's avatar
        HitachiOG
        Frequent Visitor
        2 years ago

        >> Only thing you have to watch is if you make a certain changes to the model (relationships/calculated columns) you then need to connect to the xlma end point and force a recalculation at least if you don't do a full refresh.

        Do you have any additional information on how we definitely know when this is required and when it is not?