Forum Discussion
Publishing Composite Model
Hi
I have had some issues with a model where I needed to add a table to a direct query.
As I can't change the source data I needed to do this in Power BI, but as I need the model to be live I needed it to be direct query and therefore I couldn't add a table.
And then I found Composite Models :)
I switched it on, added my table and it all worked perfectly :)
Until I had completed first stage of the model and needed to publish......
Then I was met with the error "Publishing is Disabled. The file can't be published to the Power BI service yet becasue it includes the following preview features: Composite models"
It says yet.
Does that mean that this will be activated?
Since the feature is new is the full functionality yet to come?
Or is there a way to activate publishing for composite models?
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:
24 Replies
Here is a note.
While composite models are in Preview, it is not possible to publish composite models to the Power BI service.
Thanks v-chuncz-msft
Has anyone seen anything about how long it's expected to be in preview for?
Weighing up whether to restart my model from scratch or complete it and puclish once that has been released.
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:
Hi
I have been getting this error but I don't have any composite data models at present?
I tried it the composite data model at first, then I realised that I didn't need the extra data so I deleted it.
now its telling me that there are composite data models.
Even I faced the same issue. I found an alternate way to publish on power bi service.
We can manually upload the pbix file on the service. And configure the gateway settings. It worked for me. Hope it works for you too.
Wondering how we can upload the pbix file manually but not by publishing it through power bi desktop.
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.
