I am uncertain about how to best go about what I imagine is a very typical scenario = I want to create a data set which updates from on-premises SQL Server, and at the same time I would like to be able to update the model (for instance, having added dimensions/measures to the initial set) without having to re-create all reports & dashboards.
So, I thought the solution was to get/load the dataset from a pbix file on OneDrive: that way, when I wanted to update the model I simply overwrote the file in OneDrive (having modified the pbix with PowerBI Desktop and having refreshed the data in it as well), then refreshed from PowerBI.com, and the model would extend with the new fields and update new data as well, without having to change/re-do reports. In fact, I have been doing up to now and it works fine.
BUT, since I really want the data to refresh automatically via the Personal Gateway, I went ahead and installed said Gateway and linked it to my PowerBI.com account. Now when I go through the same process of loading a new dataset from OneDrive, the refresh settings are only related to the Gateway... which means I can only refresh data through the gateway, BUT I can't refresh my model anymore as I can't say "do a one-time refresh from OneDrive to upload new model details, possibly also new query details"! -> all refresh is now understood as being through the Gateway only!
Am I looking at this wrongly? How do you set things up to be able to update/refresh both model and data when the data sits on-premises and you want the Gateway for that?
Thanks in advance for any help.