Search code examples
visual-studiossastabularsql-server-data-tools

Visual Studio hangs when clicking "Close & Update" in Tabular model

I am going crazy now with a tabular project in Visual Studio.

When I try to update a table through the Source Data property: Source Data under Properties

and then clicking on Design and then refresh the query and afterwards clicking on Home -> Close and Update the window turns grey and it hangs forever. I have to end the VS process from Task Manager in order to continue working.

There is no extra steps applied or some other logic going on in the M query (autogenerated) but still freezes and will not update the data/columns.

I have also tried doing that from the Partitions window as proposed here on MSDN but it still freezes.

Visual Studio Enterprise 2015 version, Update 3

Please save me :)

Solution

  • The solution could be to use the Partitions window instead of the Source Data It won't freeze that often when clicking "Close & Update"

    Edit: Visual Studion 2017 works much better and since I started using it, I haven't got this bug so thumbs up for fixing it :)