Mixing
DirectQuery and Composite Models
The Microsoft documentation for DirectQuery states the following:
When importing data, it is possible to combine data from multiple sources into a single model, for example, to easily join some data from a corporate SQL Server database with some local data maintained in an Excel file. This is not possible when using DirectQuery. When selecting DirectQuery for a source, it will then only be possible to use data from that single source (such as a single SQL Server database).
The documentation says that for DirectQuery only data from that single source can be used in the model. However, I thought with Composite models you could now mix DirectQuery and Import to bring data in from multiple sources.
powerbi
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
add a comment |
The Microsoft documentation for DirectQuery states the following:
When importing data, it is possible to combine data from multiple sources into a single model, for example, to easily join some data from a corporate SQL Server database with some local data maintained in an Excel file. This is not possible when using DirectQuery. When selecting DirectQuery for a source, it will then only be possible to use data from that single source (such as a single SQL Server database).
The documentation says that for DirectQuery only data from that single source can be used in the model. However, I thought with Composite models you could now mix DirectQuery and Import to bring data in from multiple sources.
powerbi
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
add a comment |
The Microsoft documentation for DirectQuery states the following:
When importing data, it is possible to combine data from multiple sources into a single model, for example, to easily join some data from a corporate SQL Server database with some local data maintained in an Excel file. This is not possible when using DirectQuery. When selecting DirectQuery for a source, it will then only be possible to use data from that single source (such as a single SQL Server database).
The documentation says that for DirectQuery only data from that single source can be used in the model. However, I thought with Composite models you could now mix DirectQuery and Import to bring data in from multiple sources.
powerbi
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
The Microsoft documentation for DirectQuery states the following:
When importing data, it is possible to combine data from multiple sources into a single model, for example, to easily join some data from a corporate SQL Server database with some local data maintained in an Excel file. This is not possible when using DirectQuery. When selecting DirectQuery for a source, it will then only be possible to use data from that single source (such as a single SQL Server database).
The documentation says that for DirectQuery only data from that single source can be used in the model. However, I thought with Composite models you could now mix DirectQuery and Import to bring data in from multiple sources.
powerbi
powerbi
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
asked Jan 1 at 20:44
Randy MinderRandy Minder
30.2k37146260
30.2k37146260
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I'm guessing that documentation is just a bit out of date. Composite modeling was released in the November 2018 Update and I think technically it's still a preview feature.
You can read more about composite models here:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53998806%2fdirectquery-and-composite-models%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm guessing that documentation is just a bit out of date. Composite modeling was released in the November 2018 Update and I think technically it's still a preview feature.
You can read more about composite models here:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
add a comment |
I'm guessing that documentation is just a bit out of date. Composite modeling was released in the November 2018 Update and I think technically it's still a preview feature.
You can read more about composite models here:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
add a comment |
I'm guessing that documentation is just a bit out of date. Composite modeling was released in the November 2018 Update and I think technically it's still a preview feature.
You can read more about composite models here:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
I'm guessing that documentation is just a bit out of date. Composite modeling was released in the November 2018 Update and I think technically it's still a preview feature.
You can read more about composite models here:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
answered Jan 1 at 20:52
Alexis OlsonAlexis Olson
14.7k21834
14.7k21834
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
add a comment |
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
In the link you provide, related to the November update, it says that Composite models are now generally available. So I guess the other documentation is out of date.
– Randy Minder
Jan 1 at 21:03
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
Yeah, their release schedule is pretty quick and it looks like the documentation doesn't always catch up right away.
– Alexis Olson
Jan 1 at 22:41
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53998806%2fdirectquery-and-composite-models%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
