Forum Discussion

kjellvs's avatar
kjellvs
Helper I
2 years ago
Solved

Synapse Realtime analytics

Dear,   I am working on a use case where I am using both tables from a lakehouse and from a KQL database. The data from the KQL database is injected in real-time, and also visualized as such. The...
Eventhouse and KQL
power bi
Real-time Analytics
  • DennesTorres's avatar
    DennesTorres
    2 years ago

    Hi,

    If your problem is about sharing the project with other developers, you can use the format PBIP and use a source control repository. The dataset and reports are supported on this format and this would solve your problem.

     

    Kind Regards,

     

    Dennes

DennesTorres's avatar
DennesTorres
Power Participant
2 years ago

Hi,

 

Your option 2, change the query mode. I understand you connect to one of the sources, then to connecto to the other you are required to add a local model, which changes the query mode. Is this a big problem?

Would you like to talk a bit more about architecture as well? You are talking about real time. In real time we usually have a hot and cold path. The hot path (which would be the KQL) would show the information exactly how it is at the moment, but it's a data intended to be discarded.

The cold path should have exactly the same data, intended to build historical reports. This is called lambda architecture, it's one of the possible architectures for that.

Are you using the lamdba architecture? Should you?


Kind Regards,

Dennes