Power BI
Visualizing Home Assistant data in Power BI
Ahhh, Power BI and Home Assistant. Two of my favorite tools. So, why not try to bring them together? I like the Home Assistant data visualizations, but they are limited - that's where Power BI can really…
Power BI Pro Tip: show 0 instead of (Blank)
Default behavior of Power BI is to show (Blank) even when summing a numerical column that happens to be all empty. Want to show 0 instead? COALESCE helps.
Azure SQL firewall settings for Power BI refresh
I do not claim that what is included in this post is the perfect way of doing things. However, some things related to Azure SQL firewall settings for Power BI data refresh caught me by surprise recently…
Working with aggregations in Power BI Desktop
Aggregations bring me back to the good old SSAS days.You can imagine that I was curious but skeptical when I tried aggregations in Power BI Desktop.