Using streaming dataset in conjunction with a database dataset

[dk15]

I'm having issues using a streaming dataset at the same time as a database dataset. I enabled "DirectQuery for PBI datasets and AS" in the "Preview options" menu. I then import data from our database using the odbc connector. On the power bi service I created a streaming dataset. Then I tried to import that dataset using the "power bi dataets" option, but I get this error.

Any ideas on what is going on and how I can get around this?

[v-cgao-msft]

Hi @dk15 ,

I edited my reply on 6/1/2022.

——————————————————————————————

Turn on the Historic data analysis option (off by default)

When Historic data analysis is enabled, the dataset created becomes both a streaming dataset and a push dataset. 

The two are different in data storage, please refer to here for details.

Real-time streaming in Power BI - Power BI | Microsoft Docs

Next connect to the dataset using desktop. Convert connection mode from Live connection to DirectQuery.

Then connect to the database and import the table. Create the model.

Hope this helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[lbendlin]

Again - I cannot confirm this as a solution.  Historic analysis is enabled for my hybrid dataset but converting the connection to Direct Query keeps failing with the above mentioned error message.

[lbendlin]

In my experience you cannot combine a streaming dataset with other datasets.