Excel is an excellent tool for analyzing data. An analyst can easily connect to and import data, perform analyses, and achieve results quickly. Export to Excel is still one of… Continue reading It’s time to stop using Power Pivot
Category: Business Intelligence
Using Power BI Incremental Refresh with Azure Data Explorer
Azure Data Explorer (ADX) is a great platform for storing large amounts of transactional data. The Incremental Refresh feature (now available for Pro users!) in Power BI makes it much… Continue reading Using Power BI Incremental Refresh with Azure Data Explorer
Automatically move your Application Insights data into Azure Data Explorer
Application Insights (AI) is a useful way of analyzing your application’s telemetry. Its lightning-fast queries make it ideal for analyzing historical data, but what happens when you start to bump… Continue reading Automatically move your Application Insights data into Azure Data Explorer
Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI
The combination of Power BI and Application Insights (AI)/Log Analytics (LA) is a powerful one. These tools provide a quick, convenient, and relatively cheap way to collect and analyze telemetry… Continue reading Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI
Dynamic time zone conversion using Power BI
Have you ever wanted to show your time data in different time zones simultaneously? Or allows users of the same report to display time values in their own time zone?… Continue reading Dynamic time zone conversion using Power BI
