Forum Discussion
Publishing Composite Model
It looks like this may be enabled in the cloud service with the October update, based on the roadmap update from last month's Business Applications summit:
It works for me, although the limitations did not work as I expected.
My composite model worked perfectly in Desktop, but after poublishing to Service some features did not work.
So I posted a question on the Service board.
I got my composite model to work perfectly on Service after a little tinkering.
So I now have a model with Import and DirectQuery live on Service :)
Hi Anonymous thegekko42
Appreciate your response on the issue with composite model on service.
thegekko42: The issue is not with import and direct query. Issue is with dual storage and direct query.
I have already raised a support ticket and I am working with Microsoft. Will update here for any sollution.
Hi :)
Just to give an update on my issue: It seems like the issue is related to the type of connector used. So we used a sql server instead of a azure sql db connector (historical reasons- but the source is azure). And that is then causing some issues in the service since it's saying we need to install a gateway. I however tried with a new test pbix file- one import table and one direct query from the same azure sql db. And then I get a different error saying it cannot determine relationships (however there is a relationship between these two tables in desktop and that's not causing any issue).
Will keep you posted on further updates.
Thanks for the update but basically the issue is the below:
1) Direct routing and Import works in service but the relationship doesn't work.
2) Dual Storage and import works in desktop and publishes in service with proper relationship but the schedule refresh is failing.
Any one has any update on this?