Let's say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory - Ok this is easy enough. We can achieve this using RLS. Rank the territories based on revenue. Sales person should be able to view the ranking of their … Continue reading How to Hack RLS to Make RANK() Work on Entire Dataset
Author: nikilprabhakar
Taking another look at ALL() and ALLSELECTED() Functions
I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions
Power BI – How to Organize Measures in a Metrics Table
Do you have measures spread across multiple tables ? Is it getting hard to find the measures ? Check out this video which talks about organizing measures. https://www.youtube.com/watch?v=w8wPyYatzMo
Power Query – Merge Function
Can I use merge function to filter data ? Yes you can and there are gotchas... Listen to the post for details: https://www.youtube.com/watch?v=ycb4qzo0nhE&t=128s
Power Query – Create Functions
How hard is it to create functions in Power Query ? Do I need to learn coding to write functions ? When should I create functions ? I answer these questions in the following post: https://youtu.be/XGlTcgELxG4
Power BI – SAP Connectors Part 3 Large Data Volumes
In this post, I cover strategies to deal with large data volumes when using SAP connectors in Power BI. https://youtu.be/snw6gpWYuTc
Power BI – SAP Connectors Part 2 Enable Trace
How to get to the log files when using SAP BW as the data source ? I answer this in the post below. https://youtu.be/7WfFDGfR6v4
Power BI – SAP Connectors Part 1
In this post, I cover things I have learnt and best practices using SAP Connectors in Power BI. Direct Query vs Import mode, Relational vs Multidimensional mode... etc. https://youtu.be/w2Vt-oGhmxU
Power BI: Control Dataset Size Using Parameters
In this post, I cover the steps to use parameters to control dataset size. Check it out. https://www.youtube.com/watch?v=7ipslDgCtss&feature=youtu.be
SAP HANA Connector – Incremental Refresh
A lot of my clients ask the following question: "Hey I am connecting to SAP HANA using import mode. I need to bring multiple years of data into Power BI for YoY analysis. This means millions of rows of data. When I try to refresh this dataset, it takes hours to complete and in most … Continue reading SAP HANA Connector – Incremental Refresh