Forum Discussion
PowerBi Capability
Hi Anonymous
Power BI can do realtime streaming, and if required can have a direct connection to a SQL style database which refreshes in realtime . However this depends more on the speed of the data feed, (the SQL server providing the data) than the Power BI service.
Dataset Size depends to some extent on the cardinality of your data. The more repetitions there are in your data the better it will be compressed in your dataset, so it's difficult to estimate size based on number of redords alone. However there are many instances of Datasets with 5-6 million rows in a Pro dataset, but as ever "it depends".
For licencing see: Power BI Free vs Pro and Premium | Burningsuit
for best practice and performance see: Power BI guidance from the CAT – BI Polar (ssbipolar.com)
Hope this helps
Stuart
Hi Anonymous
Power BI can do realtime streaming, and if required can have a direct connection to a SQL style database which refreshes in realtime . However this depends more on the speed of the data feed, (the SQL server providing the data) than the Power BI service.
Dataset Size depends to some extent on the cardinality of your data. The more repetitions there are in your data the better it will be compressed in your dataset, so it's difficult to estimate size based on number of redords alone. However there are many instances of Datasets with 5-6 million rows in a Pro dataset, but as ever "it depends".
For licencing see: Power BI Free vs Pro and Premium | Burningsuit
for best practice and performance see: Power BI guidance from the CAT – BI Polar (ssbipolar.com)
Hope this helps
Stuart