Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
We have a requirement of generating reports on PowerBI for real time transactions. We have roughly 2000,000 transactions flowing in 1 day and we would like reports generated atleast for these number of rows. The reports don't have to necessarily be updated as the data is pushed, but should show as close a real time view of the current situation as possible.
I understand that the push streaming API has a limitation of 200,000 rows for FIFO datasets and 5,000,000 for "none retention policy" Link
My questions are as follows:
Solved! Go to Solution.
Hi @Anonymous
Real-time datasets are mainly designed to display real-time data in tiles on dashboards rather than for power bi reports. If you want to utilize more features of power bi reports and show real-time data, you may consider using DirectQuery mode to create your dataset in Power BI Desktop application.
If you don't need real-time data in reports, you can also consider using Import mode to create a dataset and setting incremental refresh rule for it. You can decide for which period to store the data and only refresh the latest data. For example, store the data in latest 5 days and refresh the newly added data in latest day. And configure Scheduled refresh for this dataset.
For a push dataset, it is created as a none retention policy dataset by default. You can use the defaultRetentionPolicy query parameter to change this behavior. But for a streaming dataset, data is temporarily stored for only one hour to render the visuals on dashboard. Reference: Streaming-dataset-matrix
Regards,
Community Support Team _ Jing Zhang
Hi @Anonymous
Real-time datasets are mainly designed to display real-time data in tiles on dashboards rather than for power bi reports. If you want to utilize more features of power bi reports and show real-time data, you may consider using DirectQuery mode to create your dataset in Power BI Desktop application.
If you don't need real-time data in reports, you can also consider using Import mode to create a dataset and setting incremental refresh rule for it. You can decide for which period to store the data and only refresh the latest data. For example, store the data in latest 5 days and refresh the newly added data in latest day. And configure Scheduled refresh for this dataset.
For a push dataset, it is created as a none retention policy dataset by default. You can use the defaultRetentionPolicy query parameter to change this behavior. But for a streaming dataset, data is temporarily stored for only one hour to render the visuals on dashboard. Reference: Streaming-dataset-matrix
Regards,
Community Support Team _ Jing Zhang
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.