Forum Discussion
Take Data Stream as table for Data Modeling
- 5 years ago
Hi. Let's see if I understood to help. Streaming datasets are composed by one table. Once it's created you can consider it as a Power Bi Dataset that can be conected with Power Bi Desktop as live conection (having the ability to create measures only).
If you want to merge that data with some other data you have somewhere else, you should consider getting the data from the source that is pushing to the streaming and not getting it from the streaming data set that you have just generated. If you don't have a data source because you are pushing something that is created on the fly, consider adding to the script that is pushing the data to save it on a database too and not only sending it on power bi. That way you can keep track of the historic streaming pushes on a database to mix with other data.
I hope it makes sense.
Hi. Let's see if I understood to help. Streaming datasets are composed by one table. Once it's created you can consider it as a Power Bi Dataset that can be conected with Power Bi Desktop as live conection (having the ability to create measures only).
If you want to merge that data with some other data you have somewhere else, you should consider getting the data from the source that is pushing to the streaming and not getting it from the streaming data set that you have just generated. If you don't have a data source because you are pushing something that is created on the fly, consider adding to the script that is pushing the data to save it on a database too and not only sending it on power bi. That way you can keep track of the historic streaming pushes on a database to mix with other data.
I hope it makes sense.