Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
Anonymous
Not applicable

Error publishing a COMPOSITE model

Hello,

I am getting an error when trying to publish to my workspace? The composite (i.e. Direct connect) model works fine in desktop. It is a combination of a Live connection to a Power BI dataset plus a few manually created tables by using ENTER DATA command. I know this functionality is in PREVIEW but I was hoping someone in the community may have run into already?

 

DirectConnect.JPG

5 REPLIES 5
Anonymous
Not applicable

Hi @Anonymous ,

 

I'm a little confused about this message you said:

 It is a combination of a Live connection to a Power BI dataset plus a few manually created tables by using ENTER DATA command. 

 

Because based on my test, Power bi does not support to use Live Connection mode together with Import mode in a single pbix file:

2.4.1.1.PNG

In case, I have created a report based on a Mixed mode( using Direct Query and Live Connection) and published it to My workspace successfully.

2.4.1.2.PNG

 

It may be related to the environment, account number and many other factors. Please upgrade your Power BI Desktop to the latest version and have a try again.

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

this is supported in the newest version of PBID, this feature just went into preview.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


lbendlin
Super User
Super User

please clarify "my workspace" - is that your personal workspace, a standard workspace, or a premium workspace? For the last two, are you a member of the workspace? if so, what role?

Anonymous
Not applicable

Hello,

 

My personal workspace --

 

Thanks,

 

Jim

nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

 

users on the forum here are also having this issue, but there is still no solution mentioned.

Can you make sure you are not hitting one of the limitations mentioned here?

You should be able to publish to My workspace for example, but you can't use a dataset from My workspace.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


Helpful resources

Announcements
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.