Sync Azure Analysis Service Replicas with Azure Automation

Azure Analysis Service Replicas Azure Analysis Service lets you scale out your queries very easily through replicas. Replicas are nothing but multiple copies of your Azure Analysis Service (AAS) database. In critical times, queries can run in replicas and reduce the load on Query Processing Unit (QPU). You can read more about Analysis Service replicas … More Sync Azure Analysis Service Replicas with Azure Automation

Cascading or parent-child slicer issue in Power BI

Welcome back 🙂 It’s time to talk about one of the most ‘famous’ issues of Power BI. It appears when you have parent-child or cascading slicers in your report. Let’s say, you have a parent slicer ‘Category’ and a child slicer ‘Sub-Category’. When you change a selection in Parent, child selector doesn’t change to any … More Cascading or parent-child slicer issue in Power BI

Links in Power BI

This is just a compilation of different types of linking mechanisms in Power BI. I have explained them from use case point of view. It’s mainly written for newbies like me who are wondering which linking feature is applicable for which use case? 🙂 Tiles: Link between dashboard and reportss This is only available for … More Links in Power BI

Non-additive measures with different granularity in Power BI

I have found many articles on web regarding non-additive measures in power BI. But most of them are about inventory-type measures where normal aggregate functions are not suitable for use. However, in real life we often face situations where data providers deliver pre-calculated measures for different hierarchy levels. Numeric distribution, weighted distribution, market share etc. … More Non-additive measures with different granularity in Power BI