Combining streaming dataset & PostgreSQL based data into single semantic model

[Arul]

Hi All,

Is it possible to create a report based on two datasets and configurable in embedded application? I have the below data

1. Streaming Dataset (Published to Power BI service)

2. PostgreSQL (Connect as a Direct Query)

I need to create a report by referencing these two datasets separately; I need to bring in the Streaming Dataset as a live connection, while also incorporating the PostgreSQL data as a DirectQuery connected data source within the same report.

[MFelix]

Hi @Arul ,

For this you need to do a composite model.

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

If you add the Streaming dataset and then add the PostgreSQL in your report you are abble to do it, if the option to add another datasource is not availablel, start by select the enter data option that will pop up a message to convert the streaming dataset do direct query and then you can add the other sources you need.