Forum Discussion
Advocate IDeploy changes without Data Refresh
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.
Advocate IOk, 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?
Community ChampionI 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.
>> 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?
- lbendlin
Super User
You will know when your users report broken visuals...
