power bi
2 Topics
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 data from lakehouse is updated on daily basis, and visualizations are thus less fluent. Now, I want to combine both data in a single report; however I cannot find a way to procceed. I have tried the following options: 1) add shortcut to KQL dataset in Lakehouse (can only add as file) 2) try adding additional dataset from powerbi report (not possible in service, in desktop, this changes the query mode). 3) Edit -> we have also tried to download the report, then change the report by creating a copy of the model, adding the new KQL dataset. Publishing this report then introduces a new dataset in the workspace (which is the custom one based on the lakehouse and kql database). When my colleague then wants to make changes, they can download the file, and have to create an additional "local model", when overwritin this in the workspace, the file and connecitons then are broken. This "development" flow thus also doesn't work. How should this normally be done? It would be perfect to have both these datasets in a single report, preferably under live mode such that they can be easily maintained by different users. Hope you can help as I failed to extract this from documentation. Kind regards, KjellSolved4.8KViews0likes7Comments
Real-Time Analytics Tutorial on MS Learn Fabric dataset not real time
Hi, I just finished the tutorial and notice that the Yellow Taxi dataset (high data-rate) is not at all high rate or even updated, its only 2022 data. In the tutorial we set the refresh rate to 10 seconds indicating that more data will appear. Have i done something wring or is this just a "dry" practice? Thank you Tutorial from MS Learn: https://learn.microsoft.com/en-us/fabric/real-time-analytics/tutorial-introductionSolved3.4KViews0likes4Comments