If your model started out in Excel, but now you are forced to connect to data in a database, you do not have to stress out. Yes, unless you watch this video, you will have to rebuild everything, but if you do watch this video, I will show you how you can move your table(s) … Continue reading How to Switch Your Power BI Table to a Different Data Source Type Without Breaking Anything
Month: July 2020
Power BI Custom Visual Review: Ultimate Waterfall (Free)
TLDR – I did not like it as it was way to complex and too confusing, would much rather use the Simple Waterfall chart. You have been warned, this custom visual takes work to figure out how to use. It is not very intuitive. However, it has a boat load of features that other charts … Continue reading Power BI Custom Visual Review: Ultimate Waterfall (Free)
KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Vlog #2 is up… I talk about the channel growth – 10% in the last week – thank you! I also go over the latest Power BI updates from the team's blog. Basically, nothing super exciting, other than a few cool things that get us closer to a direct query to AS or PBI composite … Continue reading KNOWLEDGEBANK.PRO VLOG #2: Channel Update, Two Custom Visual Reviews and a Bit of Ranting
Power BI & DAX: Data Masking vs. Row Level Security (RLS)
Data Masking is vastly different from Row Level Security (RLS). Often, we get frustrated with RLS because we are trying to solve a data masking problem by using RLS techniques. Data Masking is feature in the security realm that allows us to show the totals for all the data at the high level while allowing … Continue reading Power BI & DAX: Data Masking vs. Row Level Security (RLS)
What to Do When Power BI Totals are Wrong
Have you ever gotten yourself in a situation when your calculation works great on a row by row basis, but when you look at a total, it does not match to the SUM of the individual rows? If so, the problem is not Power BI, the problem is in your calc. The good news is … Continue reading What to Do When Power BI Totals are Wrong
Power BI & DAX: How to Compare Timeseries with Different Start Dates
Let's say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot them based on number of days from the launch date. This way we can easily see which product grew to … Continue reading Power BI & DAX: How to Compare Timeseries with Different Start Dates
business intelligist 