Combine real time data streaming with local data in Power BI online

[Rob]

Hello,

I am sorry if this question has been solved already, I couldn't find anything about it.

I have a real time data streaming coming from Stream Analytics to Power BI Online.

However, I would like to combine this real time data with a fixed one.

(For example, car parking availability = real time data and parking features = fixed data)

However I do not see any solution to this problem because it is unfortunately not possible to combine data on Power BI Online.

It is possible to combine data online on Power BI Desktop apparently.

Do you have any idea on how to solve this problem ?

Thank you in advance,

Rob

[Greg_Deckler]

What I would look at doing would be to feed the data up to an Azure Event Hub and then pipe it over to Azure Stream Analytics and combine the data there, then feed that combined data over to Power BI.

[Rob]

Thank you for your answer.

I tried what you told me to do and I combined the data before sending it to Power BI Online. I can see the data of the reference data appearing but there is nothing in the table (the streaming data one still has its data like usual). My query is a simple join between 2 sets of data but I cannot see where it goes wrong...