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.
Super User"before I deploy I always have to refresh so that when I Publish, the data is up-to-date..."
That is not mandatory. Any meta data update will automatically initiate a dataset refresh anyway.
On Premium you can refresh entire datasets, individual tables (queries) and even partitions (if you use incremental refresh). The refresh request options are the same as in SSAS Tabular (because datasets are in essence the same as SSAS Tabular models).
Advocate I"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...
- lbendlin
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.