We cannot convert the value "[Table]" to type Table.

I hope to get some time tonight or tomorrow to do some experiements with my solution, hopefully being able to shed some more light on this - I supposed many users must be affected and puzzled by the error they get from the Service...

I will post here as soon as I find out more.

Update: I finally made it work - and it was your input that sent me in the right direction, Molotch, although a few other tweaks were needed. I was previously trying to remove all my merge joins (using many of these for surrogate keys), as MS support told me these were the root cause of the solution not refreshing in the Service, throwing the Table error. But apparently it was actually my initial setup, where I have a source query on azure sql server level which I am referencing out in multiple queries where in each of them I am expanding the nested Views that I need. All this to only keep one pointer at the actual source. Tweaking this to have each query point at the source directly solved the refresh issue, partly. I then recieved another similar error, only cannot convert type [List]... It turned out I had another query, this time a SPO list, that had some information in nested Lists, again expanding these Lists in the source query and THEN referencing the query into multiple dimensions and a fact, solved the issue.

I am really relieved that I don't have to rely on PowerUpdate (I am a little worried about EULA compliance here anyway..) or some other 3rd party app for updating/publishing anymore, BUT I strongly feel that this area should be given some attention by the development team, as it is directly working agains best practice modelling imo.

Hope someone finds this useful till then - and thanks for making my try once more, Molotch :-)

/RSK