Forum Discussion
Streaming data and static data in one report or visual
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
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
Since the combination seems not to be possible i tried to come up with other options for a solution:
1) use imported data source and refresh the datasource automatically => limited to 48 refrehses per day in pro dataset, which is too little for us, we want to refresh every 5 minutes
2) Using only live data and stream/push both my fast changing data and slow changing data all the time => more expensive to implement since i have to stream even slow changing data
3) Building a dashboard from different tiles some of which use live data and some of wich use imported data => cannot visualize slow changing and real time data together
every of these solutions has its drawbacks but i tend to solution number 1) since we already have the dashboards and data and do not need to rewrite everything to live data now. Do you see other other alternatives I could consider?
