Manage DirectQuery connections to a published dataset
By default, when a dataset is published to the Power BI service, a DirectQuery connection can be made to it, assuming proper permissions. This connection can be used to create new composite models on top of the dataset.
In some situations, however, you need to discourage these connections from happening. This is especially important in the composite models scenario, where you might want to prohibit creation of new composite models on top of the dataset (so-called chaining). By discouraging DirectQuery connections to a dataset, you are effectively ending the chain or stopping it from forming in the first place.
Note
Power BI will honor this setting and disable making DirectQuery connections to a dataset, but third-party tools might not and still allow users to make DirectQuery connections to a dataset even if you disabled it.
Discourage DirectQuery connections to a dataset using Power BI Desktop
To discourage DirectQuery connections to a dataset go to File > Options and settings > Options > Current File > Published dataset settings.
On this page, check the Discourage DirectQuery connections to this dataset box, and select OK.
Discourage DirectQuery connections to a dataset using third-party tools
Using third-party tools, you can discourage DirectQuery connections to a dataset by setting the DiscourageCompositeModels
property on a model to True
.
Next steps
Feedback
Submit and view feedback for