Forum Discussion
R/W endpoints
Hi GilbertQ
Do you know any article online on this subject? I was watching that webinar from Christian Wade few months ago, and he never talked about any restrictions.
In my case after changing dataset on service with tabular editor i cannot longer download both dataset and reports that are using live connection to this dataset. This does not make any sense, i already have ticket open for this but MS support is just confused and giving me generic answer ("hey we will check and let you know") when i ask for status.
So far in weeks they did nothing to provide any solution.
I know it is har to solve this issues like this on community so i was writing this post more to get an idea does anyone use this feature without any problems?
What I do is I always have a local copy of the dataset where I model and make my changes.
Only once that is done do I then deploy the changes to the PBI dataset.
This is how I would suggest developing and is considered best practice because you always work offline with a local copy. And ensures that you do not deploy a change that could break the entire model.
Thanks GilbertQ
I did it like that until they intruduced R/W endpoints for dedicated capacity. By looking on their presentatison what could be done on model while dataset is on service i tought "hey this is really going to help me with those huge datasets".
But at the end it is just not working 😕, so i will try go old way with dowloading datasets and working with local copy. It will make me less productive with large datasets, but at the moment this is probably only way to be on the safe side.
- Hi there
You can certainly do that the challenge is that the dataset only then gets changed in the service.
There is a way to script out the dataset and create it locally.