Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Using streaming dataset in conjunction with a database dataset

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

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's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.