Salvatore CagliariinMicrosoft Power BIAnalyzing Power Query with Load TracesA detailed trace is beneficial when tracking down data-load issues with Power Query. Let’s take a look at the available Diagnostics Tools.2d ago2d ago
Salvatore CagliariinTowards Data ScienceHow to Dynamically Restrict Data Import in Power QueryWhen we have a large amount of data, we might ask: Do I really need all this data in my reporting? If no, read this piece to learn more.Aug 61Aug 61
Salvatore CagliariinTowards Data ScienceHow to Manipulate the Total in Power BIIn most cases, the total aggregates the detail rows in a visual. But what if the Total should show something different?Jul 161Jul 161
Salvatore CagliariinTowards Data ScienceUsing Power BI for Planning (Warehouse) with Stock ValuesHow can we use Power BI to plan for the future using Stock-Measures? Here, I show you a possible approach.Jun 181Jun 181
Salvatore CagliariinTowards Data ScienceHow to apply RLS based on multiple columns in Power BIUsually, Data Access with RLS is based on Data from one column. But what when Data access must be controlled by multiple columns?May 23May 23
Salvatore CagliariinTowards Data ScienceOn Handling Precalculated Hierarchical Data in Power BIWhile hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Let’s see a not-so-unusual case.May 3May 3
Salvatore CagliariinTowards Data ScienceCalculating the previous value in Power BICalculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let’s see how we can solve…Apr 191Apr 191
Salvatore CagliariinTowards Data ScienceExplore all ways to implement RLS RulesImplementing row-level security in Power BI is a recurring task for developers. Let’s look at the techniques for implementing it.Apr 3Apr 3
Salvatore CagliariinTowards Data ScienceVisualize a business process through data serializationSometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.Mar 15Mar 15
Salvatore CagliariinTowards Data ScienceCalculate the percentage of the total with RLS in place in Power BIWith RLS in place, some users can see only some aspects of the data set. But what happens when they must compare the result to the total?Feb 5Feb 5