Forum Discussion
Deploy changes without Data Refresh
- 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.
"Any meta data update will automatically initiate a dataset refresh anyway."
But before it updates in the service, my users will see outdated data for 30 minutes.
This is unacceptable.
But I think I found a way - to use pipelines. I am still reseaching...
You can also use XMLA endpoint requests that allow you to specify exactly what part of the dataset/table/partition should be refreshed. Same as what you can do in regular (tabular) SSAS.
- mshparber4 years ago
Advocate I
This still doesn't answer my task to deploy only changes to report/measures without having to refresh anything (even incrementally)