Skip to main content

Power BI

New

Can't publish Import-only report once opened with Composite models turned on

Vote (3) Share
jeffshieldsdev's profile image

jeffshieldsdev on 29 Sep 2018 02:34:34

I'm getting the message:

"Publishing is disabled:
This file can't be published to the Power BI service yet because it includes the following preview features: Composite models"

When all my queries are Import--this report is also already published.

I think I opened it with the Composite models preview feature enabled and it some how thinks the queries are DirectQuery.

Maybe this is related to known bug of new queries always being DirectQuery when Composite models are enabled.

If I turn off Composite models and attempt to open my Import-only report, I get the message:

"Unable to open document
In order to open this file, the following preview features must be enabled: Composite Models"

I'm going to try this workaround and recreate all my queries: https://community.powerbi.com/t5/Issues/DirectQuery-errors-on-imported-tables-July-2018-Composite-Models/idc-p/472098/highlight/true#M29413

Comments (2)
jeffshieldsdev's profile image Profile Picture

089c31b1 f8e8-454e-9ff0-c5db5f604dec on 05 Jul 2020 23:30:49

RE: Can't publish Import-only report once opened with Composite models turned on

Although I didn't create any new queries, I did create many-to-many relationships--so maybe that activated this DirectQuery bug.

jeffshieldsdev's profile image Profile Picture

089c31b1 f8e8-454e-9ff0-c5db5f604dec on 05 Jul 2020 23:30:49

RE: Can't publish Import-only report once opened with Composite models turned on

Yes, once I switched from many-to-many back to one-to-many, I was able to publish again. So it must be many-to-many enhancement a part of Composite models.