Query Groups not supported, causes update failure

[edhans]

I just used the 5.1.12-PreRelease version.
I had a model in the service with a number of Power Query transformations, Calculation Groups, measures, relationships, etc.
I created a model in Power BI Desktop that was essentially blank - I just used "Enter Data" to get a model.

I used this new build of ALM Toolkit to populate the desktop model with the model in the service and ran into two issues.

1. If there are Power Query groups, the update fails with the error in the image below. The fix is you have to go into Power Query on the desktop and manually create the query group, then resync, then keep doing this until you have identified all query groups that exist. I had 3.
2. It doesn't update the model's compatibility level. IMHO it should. If I am going from 1601 in the service to a 1550 model in Power BI Desktop, It shouldn't force me to fire up Tabular Editor to make the compatibility level change in the desktop.

These are both very minor issues. I am extremely impressed that now we can recreate models in the service in Power BI Desktop. I want to see how it performs for unsupported objects, like Incremental Refresh partitions, when I get time. Thanks for the work!

[christianwade]

Thanks for the feedback Ed - I'm forwarding ...

[christianwade]

Hi Ed, this pre build should fix both those issues. LMK if it works for you.
https://github.com/microsoft/Analysis-Services/releases/tag/5.1.14-PreRelease

[edhans]

Worked flawlessly @christianwade - thanks!

[christianwade]

You're welcome!