Forum Discussion
Streaming data and static data in one report or visual
Hi everybody,
Im wondering what are the possibilities to combine data from streaming datasets and other more static datasets in Power BI. I have streaming data updating every minute (room occupancy) and static master data (room names which might change after some time) that needs to be updated once a month maybe. I want to show both types of these data in one report or even better in one visual because the streaming data makes more sense to the user if it is combined with master data. Is there a way to do this?
Here is an example to explain the problem better, room names should be imported from an SQL database and room occupancy should be real time data:
https://drive.google.com/open?id=1G1Mx-OlzlShD11PJcanqN0wjqRCrNPJq
Best,
Heiko
4 Replies
v-yulgu-msftMicrosoft Employee
Hi heikofri,
You want to connect to Streaming Dataset together with other data source type in Power Bi desktop, right? However, it is not supported to connect to multiple data sources once live connection to Power BI service is established. This limitation is not just applied to streaming dataset, apply to other datasets, too.
Regards,
Yuliana Gu
Hi v-yulgu-msft,
Thank you for the answer! Could you give me a suggestion how to implement my use case in Power BI instead?
Best, Heiko
- v-yulgu-msft
Hi heikofri,
As I mentioned above, the connection to service dataset including streaming dataset is live connection, it is limited to connect to only single dataset. So, per my knowledge, I couldn't find any workaround to combine streaming dataset with other data source type.
Regards,
Yuliana Gu
