0

I have a Power BI report and it allows me to get data using the import mode, direct query mode, live connect (to dataset) mode.

Also the recent feature allows me to convert the live connect mode to direct query mode so that I can combine live connect dataset with more data sources.

My goal is to connect my report to 2 live datasets in direct query mode. However, I am only able to connect to 1 live dataset in direct query mode and then get data from additional sources. Is connecting to 2 live datasets not supported?

Link: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#use-composite-models

When you use DirectQuery, composite models make it possible to create a Power BI model, such as a single .pbix Power BI Desktop file, that does either or both of the following actions:

Combines data from one or more DirectQuery sources. Combines data from DirectQuery sources and import data.

Improve this question
2
  • Is this question specifically related to connecting to two Power BI datasets at the same time? Because that is straightforward - just add a new data source and choose Power BI report. Perhaps you need premium capacity? Commented Nov 15, 2022 at 12:37
  • On my report, when I do a live connect to another Power BI dataset, it doesn't allow me to add any more data sources. Recently there is a new feature that needs enabling, and it then allows me to connect to other data sources when my report is already connected to another Power BI database (it converts the live connection into direct query). But it doesn't allow me to connect to another Power BI dataset. Commented Nov 15, 2022 at 12:41

1 Answer 1

Reset to default
1
+50

Step 1: Ensure settings are correct. It is currently a preview feature to enable DQ for PBI datasets and AS:

enter image description here

Step 2: Add a new source, choose Power BI Dataset.

enter image description here

Step 3: Add another source, this will pop up. Choose to add a local model:

enter image description here

After another data set has been added, the storage mode is still DQ:

enter image description here

This was done on Version: 2.110.1161.0 64-bit

Improve this answer
Sign up to request clarification or add additional context in comments.

14 Comments

When I make relationship between 2 models, then is the inner or left join?
The join depends on the relationship: Many-many is an inner join, one-one is a full outer join, one-many is a right outer join and many-one is a left outer join. See this relevant question: community.powerbi.com/t5/Desktop/…
There is a concept of inter vs intra group relationships. For example no table expansion happens with inter group relationships. And by default inter group relationships are M:M. Do any such rules apply on relationships setup between direct query pbi datasets?
But you are looking at a mixed/composite models with several sources: Each source, including the Vertipaq cache of imported data, is considered to be a source group. Model relationships can then be classified as intra source group or inter/cross source group. In any event you can just test and see what is valid for your model.
No no it doesn't work like that. If not for table expansion then there is internal technique used to filter. So effectively the result is same. Table expansion is just more efficient.
|

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.