CODEWITHSUNDEEP
powerbi
variable
variable

Reputation: 9736

How to connect to 2 live datasets in a report?

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.

Upvotes: 0

Views: 1694

Answers (1)

Marcus
Marcus

Reputation: 4015

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

Upvotes: 1

Related Questions